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: Fri, 21 Oct 2011 08:19:45 -0700
- Thread-topic: Excel 2011: Select noncontiguous columns
On 10/20/11 4:37 PM, "David Wignall" <email@hidden> wrote:
>> set column width of cell "F1;H1;K1;N1;Q1" to 14
>
> Aha, Regional Settings in effect! The ',' character is the separator
> for English based systems but not elsewhere.
If I remember correctly, I think this applies in countries where ',' is the
character used as a decimal point.
The 'union' command will apply everywhere, when you need a version that
avoids this issue. It works also with A1 terminology:
set myRange to union range1 "F1" range2 "H1" range3 "K1" range4 "N1"
range5 "Q1"
set column width of myRange to 14
--
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