I'm trying to set Pivot table field names with the following code. For Each Region In Regions
R Ron McCormick Nov 7, 2003 #1 I'm trying to set Pivot table field names with the following code. For Each Region In Regions
T Tom Ogilvy Nov 7, 2003 #2 And what happens? Does the variable region hold a legitimate item value from the PivotField "Region"? I have found looping throught the items to find a match and setting the current page to the matched item works when this construct doesn't.
And what happens? Does the variable region hold a legitimate item value from the PivotField "Region"? I have found looping throught the items to find a match and setting the current page to the matched item works when this construct doesn't.
