• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Excel Last Cell
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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<-


References: 
 >Re: Excel Last Cell (From: Larry McMunn <email@hidden>)

  • Prev by Date: Find Insertion Point
  • Next by Date: Re: OSA 1.2.2 conflict Was:Scripter - Slow as a Snail. . .
  • Previous by thread: Re: Excel Last Cell
  • Next by thread: date snippet
  • Index(es):
    • Date
    • Thread