View Full Version : Need Visual Basic code for macro to select pivot field name indirectly

05-09-2013, 06:07 PM
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 ?