Results 1 to 1 of 1
2003-02-27, 21:47 #1
- Join Date
- Feb 2001
- Columbia, South Carolina, USA
- Thanked 0 Times in 0 Posts
Select pivottable page value (Excel 2k)
How do you programmatically select a value for a pagefield in a pivottable?
I tried the following where "projCode" contains the value I want selected from the list of valid values for the pagefield:
<span style="background-color: #FFFF00; color: #000000; font-weight: bold">ActiveSheet.PivotTables("Mthly Proj Summary PivotTable").PivotFields ("Project").CurrentPage = projCode</span hi>
However, an invalid project code value overlays the previously selected pagefield value, removing the original from the listbox! I'm looking for an approach that will either error in this situation or, at a minimum, take no action.