Re: ongoing battle with Excel 2004
Re: ongoing battle with Excel 2004
- Subject: Re: ongoing battle with Excel 2004
- From: Shane Stanley <email@hidden>
- Date: Mon, 28 Nov 2005 14:42:24 +1100
- Thread-topic: ongoing battle with Excel 2004
On 28/11/05 9:57 AM, "Robert Poland" <email@hidden> wrote:
> With an Excel 2004 window open the following script and with at least
> a hundred variations of it I get an error. I am looking for the row
> number of the last cell as a variable. Any clues?
>
> tell application "Microsoft Excel"
> activate
> activate object (special cells (cells of active sheet) type
> cell type last cell)
> set endingRow to range of (activate object (special cells
> (cells of active sheet) type cell type last cell))
> end tell
tell application "Microsoft Excel"
set endingRow to first row index of last row of used range of active
sheet
end tell
--
Shane Stanley <email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden