Re: Excel: hide multiple columns with Applescript
Re: Excel: hide multiple columns with Applescript
- Subject: Re: Excel: hide multiple columns with Applescript
- From: David Wignall <email@hidden>
- Date: Sun, 20 Mar 2011 11:44:02 +1300
On 20 Mar 2011, at 7:04 AM, Cameron Knowlton wrote:
> I've been working more on my Excel scripting, and hope someone here can help with an efficiency.
>
> Currently, I use a loop to hide excessive pivot table columns:
This specifically hides all columns of a pivot table:
set Pivot_Table to pivot table (1) of active sheet
set Pivot_Columns to column range of Pivot_Table
set Entire_Columns to entire column of Pivot_Columns
set hidden of Entire_Columns to true
More generally this will hide columns on any sheet:
set hidden entire column of range ("$B:$J") to true
--
Dave
_______________________________________________
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