Re: Excel: newby question
Re: Excel: newby question
- Subject: Re: Excel: newby question
- From: Paul Berkowitz <email@hidden>
- Date: Fri, 03 May 2002 07:40:43 -0700
On 5/3/02 6:44 AM, "Olivier Berquin" <email@hidden> wrote:
>
Hi all,
>
>
How can I have the "LastCell" in Excel?
>
>
I try this without result...
>
>
tell application "Microsoft Excel"
>
Activate
>
set TheLastOnt to the LastCell
>
end tell
>
>
What's the "range" ? What's the direction ?
>
>
Try
tell application "Microsoft Excel"
set TheLastOnt to SpecialCells (UsedRange of ActiveSheet) Type
xlLastCell
end tell
--> Range "R188C13" of Worksheet "Sheet1" of Workbook "Name Here""
That gets you the range. I'm not sure what you mean by the "direction".
--
Paul Berkowitz
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.