Excel: How to generate a list of pivot tables in a file
I've for a TOC for the sheet and can use "Paste List" to get a list of
named ranges, but can someone point me towards the code for generating
a list of the pivot tables in a file?
I'm needing to go thru the file clean up the naming conventions and
then update the subroutines to use the updated names.
Something comparable to ActiveWorkbook.Sheets.Count, I guess?
Thanks,
Neva
|