Using Dynamic Ranges With Macros

[Guest]

I am creating a macro that takes a variable length data set and moves it into a pivot table. Does anyone know of a way where I can specify a variable range for the data set being moved into the pivot table?

Jeff

 

[Debra Dalgleish]

You can use a dynamic formula to define the source range for your Pivot
Table. There are some instructions here:

http://www.contextures.com/xlPivot01.html#Dynamic