Re: Determining
Re: Determining
- Subject: Re: Determining
- From: Stan Cleveland <email@hidden>
- Date: Tue, 27 Nov 2007 01:03:57 -0800
- Thread-topic: Determining
On 11/26/07 6:42 AM, Justin Laden wrote:
> I'm attempting to return the row number of last cell with data in a
> Excel table. Is there a way to do this?
Assuming Excel 2004, this should work (watch for text wrap):
tell application "Microsoft Excel"
set lastRow to first row index of (special cells range "A1:IV65535" type
cell type last cell)
end tell
You can use a smaller range than "A1:IV65535" if you have some idea where
the "last cell" is.
HTH,
Stan C.
_______________________________________________
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
| References: | |
| | >Determining (From: "Justin Laden" <email@hidden>) |