tell application "Microsoft Excel" set ac to get address of active cell set rw to last word of ac #win ugly log ("Active cell: " & ac & return & "Row from Active Cell: " & rw) end tell
Is there a less ugly way to pull the column or row number from a cell reference than using words as per line 3.
Also how can one construct a cell reference programatically to columns (rows are easy because they are integer values?
set col to column (1) set col1 to get address of col set col2 to second word of col1 set rw to 54 set r to range (col2 & rw) log value of r Is there a cleaner way to turn a integer into a column reference than above? |