Re: Re[2]: Uniquely identify range in MS Excel
Re: Re[2]: Uniquely identify range in MS Excel
- Subject: Re: Re[2]: Uniquely identify range in MS Excel
- From: David Wignall <email@hidden>
- Date: Thu, 19 May 2011 18:23:14 +1200
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
--
Dave _______________________________________________
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