Re: Re[4]: Uniquely identify range in MS Excel
Re: Re[4]: Uniquely identify range in MS Excel
- Subject: Re: Re[4]: Uniquely identify range in MS Excel
- From: David Wignall <email@hidden>
- Date: Thu, 19 May 2011 19:34:59 +1200
On 19 May 2011, at 7:07 PM, Leonid Bogdanov wrote:
> David,
>
> Thank you for your answer!
> What I meant with "how can I get a string representation of any range" was "how can I get a string key of a range object in AppleScript?"
>
> tell app "Microsoft Excel"
> set r1 to row 1 of active sheet of active workbook
> get ???? of r1
> tell app
get address of r1
returns "$1:$1". Is this what you want?
> Thu, 19 May 2011 18:23:14 +1200 letter from David Wignall <email@hidden>:
>
>>
>> On 19 May 2011, at 5:15 PM, Leonid Bogdanov wrote:
>>
>>> Hello, Stan!
>>>
>>> Ok, but how can I get a string representation of any range (cell, row,
>> range consisting of several rectangular areas)?
>>
>> I'm not Stan but:
>>
>> Range ("A1") refers to a cell
>>
>> Range ("A1:A10") refers to several cells
>>
>> Range ("A1: A10, B2, C3:C8, D2:F2, G3, H7:H12") refers to a non-contiguous
>> range
>>
>> Range("A:A") refers to an entire column
>>
>> Range ("42:42") refers to an entire row
>>
>> Note also that a range has properties of entire column, entire row and current
>> region that may also be useful to you
_______________________________________________
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