Re: Excel 2011: Select noncontiguous columns
Re: Excel 2011: Select noncontiguous columns
- Subject: Re: Excel 2011: Select noncontiguous columns
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 20 Oct 2011 01:27:12 -0700
- Thread-topic: Excel 2011: Select noncontiguous columns
On 10/20/11 12:25 AM, "Olivier Berquin" <email@hidden> wrote:
>
> I really don¹t understand what is happening.
It's a built-in limitation, but not a bug.
You're supposed to be able to do almost exactly what you wanted, this way:
tell application "Microsoft Excel"
tell active sheet
set myRange to union range1 column 6 range2 column 8 range3 column
11 range4 column 11 range5 column 14 range6 column 17
end tell
myRange
set bold of font object of myRange to true
--set width of myRange to 14 --?
end tell
It (the 'union' command does) works as far as creating and getting myRange,
and it will also set the font of the whole range to bold. That's because
myRange is a range, and a range can have a single font object, whose
properties, like bold, can be set. But a range does not have a 'column
width', only a total width, which makes no sense for a range of
non-contiguous columns. The same applies even if you refer to it as range
"F:F,H:H,K:K,N:N,Q:Q", as you found.
--
Paul Berkowitz
_______________________________________________
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