Re: Excel Last Cell
Re: Excel Last Cell
- Subject: Re: Excel Last Cell
- From: Craig Sutherland <email@hidden>
- Date: Thu, 14 Dec 2000 21:58:02 -0600
Larry,
I believe that Excel counts items in arrays starting with base zero rather than one, at least it is that way in VB.
Craig Sutherland
>
This isn't pretty, but it works all the time for me:
>
>
tell application "Microsoft Excel"
>
activate
>
+event miscdosc; "SELECT.SPECIAL(11)"
>
end tell
>
>
Often we forget that recordability can be very valuable even if the results are ugly.
>
>
This line of code was generated by:
>
>
1. Pulling down the "EDIT" menu to "GoTo"
>
2. Clicking the "Special" button
>
3. Clicking the "Last Cell" button
>
4. Clicking the "OK" button
>
>
Why "(11)" when the button is the 12th, I don't know, just more of that wonderful programming bestowed upon us by the Gates crew.
>
Good Scripting! :-)
->snip<-