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 08:44:19 -0700
- Thread-topic: Excel 2011: Select noncontiguous columns
Title: Re: Excel 2011: Select noncontiguous columns
On 10/20/11 3:28 AM, "Olivier Berquin" <email@hidden> wrote:
Never mind, I’ll use my script…
set column width of column 6 to 14
set column width of column 8 to 14
set column width of column 11 to 14
I think it’s the fastest way.
Thank you all for your help, appreciated as always.
The one I sent a few hours ago is faster, and is easy, using column numbers... I suppose it takes about the same time to type.
tell application "Microsoft Excel"
tell active sheet to set myRange to union range1 column 6 range2 column 8 range3 column 11 range4 column 11 range5 column 14 range6 column 17
set column width of myRange to 14
end tell
--
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