Re: Excel Range Questions
Re: Excel Range Questions
- Subject: Re: Excel Range Questions
- From: David Wignall <email@hidden>
- Date: Sat, 13 Mar 2004 10:01:33 +1300
on 13/03/2004 5:34 AM, Oakley Masten at email@hidden wrote:
>
Good Morning to all again
Good morning to you, too, my friend :)
>
I am working on a script to rename files using an Excel Spread sheet
>
for reference.
>
I first needed to know the total number of rows so I wrote the
>
following script to find out.
>
>
It works fine but because I want to use the most elegant and therefore
>
simple code possible is there a better way?
<snip>
>
Thanks in advance
tell application "Microsoft Excel"
set NumberOfTheLastRow to Row of the ((LastCell Direction xlDown) of the
CurrentRegion of Range ("R1C1")) -- all one line
end tell
--
Dave
_______________________________________________
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.