Posted to microsoft.public.excel.programming
|
|
Change Pivot Table PageArea Selection
Take a look at this:
http://www.contextures.com/xlPivot04.html
Look here too:
http://www.contextures.com/xlPivot01.html
Notice the dozen or so examples at the bottom of the page; that may help you
too.
Regards,
Ryan---
--
RyGuy
"JMay" wrote:
My Current Pivot table (Named Pivottable1) on my sheet named MyPT has a Page
Area with Values (ALL, 1,2,3,4,5). I need to Change it from another sheet
named Report!Range("b4").value - that would only contain the values, 1 to 5.
When I enter into Cell B4, say 5 -- I need for my Pivottable1 (on MyPT
sheet) to filter the PageArea selection to 5, and REFRESH the PT.
How can I do this?
Thanks in Advance for any assistance...
|