Determining
Determining
- Subject: Determining
- From: Oakley Masten <email@hidden>
- Date: Mon, 26 Nov 2007 13:43:53 -0800 (PST)
"Justin Laden" <email@hidden> wrote:
Hi everyone,
I'm attempting to return the row number of last cell
with data in a
Excel table. Is there a way to do this?
Try this:
tell application "Microsoft Excel"
set cols to count of columns of used range of active
sheet
set rws to count of rows of used range of active
sheet
--you pick the row and column for the info
set zdata to (value of cell 6 of column 4 of active
sheet)
end tell
Oakley
_______________________________________________
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