Re: Excel 2011: Select noncontiguous columns
Re: Excel 2011: Select noncontiguous columns
- Subject: Re: Excel 2011: Select noncontiguous columns
- From: Olivier Berquin <email@hidden>
- Date: Thu, 20 Oct 2011 12:28:39 +0200
hi Olivier,
try this: (so use ; instead of ,)
tell application "Microsoft Excel"
tell active workbook
tell active sheet
set myRange to column ("F:G;I:J")
set column width of myRange to 5
end tell
end tell
end tell
best regards,
\\Jan
Yes, this one work!
But it’s very slow… verrrrrrrrrrryyyyyyyyyyyyyy slow!
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.
_______________________________________________
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