• 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[2]: Uniquely identify range in MS Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re[2]: Uniquely identify range in MS Excel


  • Subject: Re[2]: Uniquely identify range in MS Excel
  • From: Leonid Bogdanov <email@hidden>
  • Date: Thu, 19 May 2011 09:15:35 +0400

Hello, Stan!

  Ok, but how can I get a string representation of any range (cell, row, range consisting of several rectangular areas)?


Wed, 18 May 2011 12:08:20 -0700 letter from Stan Cleveland <email@hidden>:

> On May 18, 2011, at 3:57 AM, Leonid Bogdanov wrote:
>
> >  Any thoughts on how to uniquely identify a MS Excel range by a number or a
> string key?
> >  So that by this key one can quickly get a range from a collection of all
> ranges.
> >
> >  I can't use its 'name' property, because after setting it, it will be
> visible by a user.
>
> Hi Leonid,
>
> Excel itself uses a 'range' object, of which the string portion looks like it
> might do the trick:
>
> set rangeKey to "[Workbook1.xls]Sheet1!$A$1:$D$14"
>
> tell application "Microsoft Excel 2008"
> set myFormulas to formula of range rangeKey
> tell font object of range rangeKey
> set {fontName, fontStyle, fontSize} to {name, font style, font size}
> end tell
> end tell
>
> Stan C.
>
> _______________________________________________
> 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

  • Follow-Ups:
    • Re: Re[2]: Uniquely identify range in MS Excel
      • From: David Wignall <email@hidden>
References: 
 >Uniquely identify range in MS Excel (From: Leonid Bogdanov <email@hidden>)
 >Re: Uniquely identify range in MS Excel (From: Stan Cleveland <email@hidden>)

  • Prev by Date: Re: Property of a record
  • Next by Date: Re: Re[2]: Uniquely identify range in MS Excel
  • Previous by thread: Re: Uniquely identify range in MS Excel
  • Next by thread: Re: Re[2]: Uniquely identify range in MS Excel
  • Index(es):
    • Date
    • Thread