• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Re[4]: Uniquely identify range in MS Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re[4]: Uniquely identify range in MS Excel


  • Subject: Re: Re[4]: Uniquely identify range in MS Excel
  • From: Christian Prinoth <email@hidden>
  • Date: Thu, 19 May 2011 09:31:35 +0200

get address

On Thu, May 19, 2011 at 09:07, Leonid Bogdanov <email@hidden> 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


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


 _______________________________________________
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

References: 
 >Re[2]: Uniquely identify range in MS Excel (From: Leonid Bogdanov <email@hidden>)
 >Uniquely identify range in MS Excel (From: Leonid Bogdanov <email@hidden>)
 >Re: Re[2]: Uniquely identify range in MS Excel (From: David Wignall <email@hidden>)
 >Re[4]: Uniquely identify range in MS Excel (From: Leonid Bogdanov <email@hidden>)

  • Prev by Date: Re[4]: Uniquely identify range in MS Excel
  • Next by Date: Re: Re[4]: Uniquely identify range in MS Excel
  • Previous by thread: Re[4]: Uniquely identify range in MS Excel
  • Next by thread: Re: Re[4]: Uniquely identify range in MS Excel
  • Index(es):
    • Date
    • Thread