Re[6]: Uniquely identify range in MS Excel
Re[6]: Uniquely identify range in MS Excel
- Subject: Re[6]: Uniquely identify range in MS Excel
- From: Leonid Bogdanov <email@hidden>
- Date: Thu, 19 May 2011 11:38:45 +0400
Yes, thank you! I overlooked it, my bad.
Thu, 19 May 2011 19:34:59 +1200 letter from David Wignall <email@hidden>:
>
> 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
_______________________________________________
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