MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro for Pivot Table


Posted by Dee on May 17, 2001 8:12 AM

How do you write a macro for a pivot table when the data range is always changing? Sometimes I will have 200 rows, sometimes 100 rows of data.


Posted by Dave Hawley on May 17, 2001 9:26 PM


Hi Dee

"Dynamic Ranges" are ideal for Pivot Tables and Charts. I have many examples of them on my Website (OzGrid Business Applications) under "Dynamic Ranges" the will help you out.


If you are still want code to do this have a look at my "VBA Tips and Tricks" Page there is an example of how to redefine a range automatically


Dave

OzGrid Business Applications