Re: Uniquely identify range in MS Excel
Re: Uniquely identify range in MS Excel
- Subject: Re: Uniquely identify range in MS Excel
- From: Stan Cleveland <email@hidden>
- Date: Wed, 18 May 2011 12:08:20 -0700
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