View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Tan Greg Tan is offline
external usenet poster
 
Posts: 3
Default List PivotTables

I am working with a spreadsheet that contains 15 pivot tables, and I am
writing a macro to update them programatically. Is there a way to list ALL
the pivot tables in a sheet without actually going to them and
right-clicking, going to Table Options and seeing the name there? TIA
--
Greg Tan