Using Dynamic Ranges With Macros

J

Jeff M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Based on Dynamic Variables (What-if Scenario) 0
VBA word change keys 0
Excel does not accept text format! 0
Need Help with Macro Security 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table Data Aggregation 0
Multiple Tables and Multiple Pivot Tables Help 0

Top