Re: Need help: Really silly Excel 2004 question
Re: Need help: Really silly Excel 2004 question
- Subject: Re: Need help: Really silly Excel 2004 question
- From: Paul Berkowitz <email@hidden>
- Date: Wed, 13 Oct 2004 08:59:24 -0700
On 10/13/04 4:26 AM, "Shane Stanley" <email@hidden> wrote:
> You can get the addresses in "$A$1" format like this:
>
> tell application "Microsoft Excel"
> set myUsedRange to used range of sheet 1 of workbook 1
> get address (cell 1 of myUsedRange) reference style A1
> end tell
>
> Although in your case you might want "get address local" instead.
get address local
gets the very same "$A$1" no matter where you are in Excel 2004. The
differences show up - not in Australia, but in France, Germany and localized
versions of Excel - using the R1C1 type references only.
get address local (cell 1 of myUsedRange) reference style R1C1
--> "R1C1" -- in English-language versions of Excel
--> "L1C1" -- in French-language versions of Excel
--> "Z1S1" -- in German-language versions of Excel
(In previous versions of Excel, there was a terrible bug in
non-English-language localizations whereby the localized L1C1-tc. address
needed to be used to refer to a cell or range, but Excel itself returned the
English-format R1C1 when evaluating terms like UsedRange , and then would
error when you tried to use the result because it didn't understand its own
answers! Hence the change to the A1 and "$A$1" format in 2004 when referring
to cells and other ranges "by name".)
You might perhaps have been thinking of
get address without row absolute and column absolute
--> "A1"
?
--
Paul Berkowitz
_______________________________________________
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