-
Need Visual Basic code for macro to select pivot field name indirectly
I'm trying to create a macro that can select a field in a pivot table field list and move it to the values area, but indirectly.
Doing this with a hardcoded field name is no problem (the Indirect function will do this) however I'd like the code to select the field dynamically based on a value of a spreadsheet cell.
Does anyone know how this can be done ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules