Excel - getting contents of row #r in named range

Scripting Forums AppleScript | Classic Mac OS
,
#1

Goal = getting contents of row #r in named range, for example:


tell application "Microsoft Excel"
	set gAcceptPrimeAssignment to get range "Accept_Prime_Assignment" of active sheet of active worksheet
	set value to GetValue(4, gAcceptPrimeAssignment)
end tell

on GetValue(inRow, ofRange)
	
	tell application "Microsoft Excel"
		
		set rng to get range ofRange of active sheet of active workbook
		
		tell rng to return contents of row inRow
		
	end tell
	
end GetValue

Does not work as shown, but will work, for example when I hardcode “A1:D1” for ofRange inside GetValue?

#2

Found my problem = I was not passing a string to GetValue as required, but the range object; so naturally it did not work.