Select Worksheets after ShowPages Page Field processed 1

[uncled]

I've got a pivot table with All as the Page Header and am using the ShowPages method to create indiviual worksheets for each item in the Page field.

I would like to be able to select all these new worksheets and perform some formatting such as tab color, alignments, etc...on all these new sheets without having to loop through each one. Even if I looped through each one, the # items in the page field will change, so am hesistant to try to hard-code and worksheet selection formula.

I have other worksheets besides these new ones, so I can't simply cycle through all of them..I need to only cycle/select the ones created from the ShowPages method.

Thanks,
-ue

 

[SkipVought]

Do you have other PivotTables as well?

perhapse you could...

dim ws as worksheet, pt as pivottable
for each ws in worksheets
  for each pt in ws.pivottables
     with pt
        'do your formatting here
     end with
  next
next

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[uncled]

Thanks for the reply Skip!! Yes, I do have other pivot tables in the workbook, they each have different PivotNames. Is there a way to specify in the look just to look at the Pivot Tables that have a specific PivotName? What does Excel to when you create multiple pivot tables via the ShowPages method...does it index them based upon the PivotName? If so, could I also cycle through these via an index?

ths,
ue

 

[SkipVought]

I don't know, but you can surely find out...

dim ws as worksheet, pt as pivottable
for each ws in worksheets
  for each pt in ws.pivottables
     msgbox pt.name & " on " & pt.parent.name
  next
next

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[uncled]

Thanks Skip!!! Worked perfectly! Thanks for the idea...i'm a bit rusty in my vba coding and appreciate you help with these seemingly simple questions

-ue