get row number of first empty cell in Excel
get row number of first empty cell in Excel
- Subject: get row number of first empty cell in Excel
- From: Mason <email@hidden>
- Date: Sun, 13 Dec 2009 14:43:11 -0800 (PST)
Hey AppleScripters,
I have an Excel document which I am working with and
though I know how to find the first empty cell in a range
I do not know how to get the exact number of the cell.
So my script contains:
tell application "Microsoft Excel"
set foundRange to find range "A:A" what ""
end tell
The result is:
range "'[spreadsheet1.csv]spreadsheet1.csv'!$A$962" of application "Microsoft Excel"
I want to extract the '962' row number out of that result so I can set it to
a variable and perform other functions in the script.
I inserted another line: "get properties of foundRange" and then
played around with text item delimiters but couldn't get it.
Does anyone know how to extract the row number of the first empty cell and then set it to a variable?
Thanks in advance for
any help!
- Mason Rove |
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden