Re: Excel: hide multiple columns with Applescript
Re: Excel: hide multiple columns with Applescript
- Subject: Re: Excel: hide multiple columns with Applescript
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 20 Mar 2011 13:14:46 -0700
- Thread-topic: Excel: hide multiple columns with Applescript
On 3/20/11 11:02 AM, "Cameron Knowlton" <email@hidden> wrote:
> I feel I'm very close here, but just not landing it.
Throw in a few explicit 'get' commands if trying to get a property of a
property in a single line. That sometimes helps (and probably also explains
why David used so many lines, setting just one property per line).
For example (and without testing), does this help in your last example?
set pivotTable to pivot table "myPivotTable" of currentSheet
tell pivotTable
set hidden of (get entire column of (get range "$D:$J")) to true
end tell
...or just one of those 'gets' (first one, maybe)?
--
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