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


References: 
 >Excel last cell (From: "Pete Willis" <email@hidden>)

  • Prev by Date: Re: info for file help...
  • Next by Date: Re: scripting the launcher
  • Previous by thread: Re: Excel last cell
  • Next by thread: Re: Excel last cell
  • Index(es):
    • Date
    • Thread