Re: Excel
Re: Excel
- Subject: Re: Excel
- From: John Baltutis <email@hidden>
- Date: Wed, 11 Feb 2009 17:34:15 -0800
On 2/11/09, Deivy Marck Petrescu <email@hidden> wrote:
> 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.
Maybe so, then he should have included "despite what the dictionary displays"
with his "The R1C1 cell-address terminology cannot be used in Excel 2004 or
2008. Only the A1 terminology." statement. One would think that over its four
years of existencs MS would have taken it out of Excel 04's dictionary or fixed
it. I have no comment on '08.
_______________________________________________
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