Re: Excel last cell
Re: Excel last cell
- Subject: Re: Excel last cell
- From: Shane Stanley <email@hidden>
- Date: Thu, 14 Dec 2000 12:33:33 +1100
On 14/12/00 2:52 AM +1000, Pete Willis, email@hidden, wrote:
>
I am having problems getting the last cell of a large imported text file in
>
Excel [snip] Is there any other way
>
to get the number of used rows as I can't seem to find one and I'm getting
>
quite frustrated now.
Play with these:
tell application "Microsoft Excel"
Row of last Row of UsedRange of Worksheet 1
set x to UsedRange of Worksheet 1
Row of Row -1 of x
Column of Column -1 of x
Cell -1 of x
end tell
--
Shane Stanley, email@hidden