View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Is it possible to Macro a Pivot Table?

"jeannie v" wrote...
I have a document in which the data is completely macro'd, except that I
need to perform 3 Pivot Tables from the data. Is it possible to Macro a
Pivot Table? If so, how would I do that?


Experimentation is always a good idea. Turn on the macro recorder just
before you create a pivot table manually, create it, turn the macro recorder
off, then see what it recorded.