View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Can we create pivot table dynamically

Sure. Use the macro recorder to get the code. Tools, Macro, Record Macro.
Be prepared to do modifcation to the result.to make it useful. For example,
Excel records the range of data that you have. If you later expand the
data, then the code is not right.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"priya " wrote in message
...
Can we create pivot table dynamically through coding in vba


---
Message posted from http://www.ExcelForum.com/