Re: Excel
Re: Excel
- Subject: Re: Excel
- From: Deivy Marck Petrescu <email@hidden>
- Date: Wed, 11 Feb 2009 17:28:34 -0500
On Feb 8, 2009, at 6:59 PM, John Baltutis wrote:
On 2/8/09, Paul Berkowitz <email@hidden> wrote:
On 2/8/09 11:44 AM, "Deivy Marck Petrescu" <email@hidden>
wrote:
I don't understand what you're working with here. Nor do I
understand where
the R3 comes from in the first statement of the script. What is
"RC[-1]"
meant to indicate and how does it end up as "R3" in the first
example and as
"RC[-1]" in the second example?
I don't know about the newer versions, but in excel X, you can
refer tocell
"A1" as "A1" or as "R1C1", the latter means "row 1 column 1".
The R1C1 cell-address terminology cannot be used in Excel 2004 or
2008. Only
the A1 terminology.
Really?? From the Excel 2004 dictionary, we have, "reference style
A1/R1C1] :
Specifies what reference style should be returned. The default is
A1." I don't
have 2008, so can't verify; however, since macros no longer work,
I'll leave
that for you to ascertain.
Hi John,
Just for the record, Excel 2008 also has the same property, but if you
try to set it or read it it has no effect or it returns missing value.
So, even though it is there it is not really working.
Also I tried set value of cell "R1C1" to whatever and got an error.
So, may be Paul is right.
Deivy Petrescu
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
| References: | |
| | >Re: Excel (From: John Baltutis <email@hidden>) |