Re[4]: Uniquely identify range in MS Excel
Re[4]: Uniquely identify range in MS Excel
- Subject: Re[4]: Uniquely identify range in MS Excel
- From: Leonid Bogdanov <email@hidden>
- Date: Thu, 19 May 2011 11:07:23 +0400
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
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
>
> --
> 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
_______________________________________________
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