• 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
ongoing battle with Excel 2004
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

ongoing battle with Excel 2004


  • Subject: ongoing battle with Excel 2004
  • From: Robert Poland <email@hidden>
  • Date: Sun, 27 Nov 2005 15:57:31 -0700

Hi,

With an Excel 2004 window open the following script and with at least a hundred variations of it I get an error. I am looking for the row number of the last cell as a variable. Any clues?

tell application "Microsoft Excel"
activate
activate object (special cells (cells of active sheet) type cell type last cell)
set endingRow to range of (activate object (special cells (cells of active sheet) type cell type last cell))
end tell


Tia,
--
Bob Poland - Fort Collins, CO
http://www.ibrb.org/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


  • Follow-Ups:
    • Re: ongoing battle with Excel 2004
      • From: Shane Stanley <email@hidden>
  • Prev by Date: "icon note" in Tiger now a generic icon
  • Next by Date: Re: "icon note" in Tiger now a generic icon
  • Previous by thread: Re: "icon note" in Tiger now a generic icon
  • Next by thread: Re: ongoing battle with Excel 2004
  • Index(es):
    • Date
    • Thread