Dynamic Ranges / Pivot Tables / Macros 1

[DSerr77]

Hi,

I am trying to create a macro that determines the range of values and then creates a pivot table off of my data. The problem I am having is that the # of rows in my data set expands an contracts. If I use the Pivot table wizard it always refers to the range of the first time. Any suggestions?

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=1331

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886