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 02:25:39 -0700
- Thread-topic: Excel 2011: Select noncontiguous columns
On 10/20/11 2:15 AM, "David Wignall" <email@hidden> wrote:
>
> On 20 Oct 2011, at 9:27 PM, Paul Berkowitz wrote:
>
> A range object does have a column width. It is the width of each column that
> comprises the range.
Indeed it does! I don't know how I missed that (well...). And that works
perfectly for me here (Excel 2008):
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
--range "F:F" H:H,K:K,N:N,Q:Q"
set column width of myRange to 14
end tell
This works. All those columns change their width 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