Re: Excel Last Cell
Re: Excel Last Cell
- Subject: Re: Excel Last Cell
- From: Larry McMunn <email@hidden>
- Date: Thu, 14 Dec 2000 10:38:56 -0500
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! :-)
Larry McMunn
President
McMunn Associates, Inc.
Specialists in automated Data Visualization thru Apple products
Collingswood, NJ
(856) 858-3440
---------------------------------------------------------------