Name of values
 

Hi guys. Please help. I have a macro that extracts values from a pivot
table. The macro goes through each field, swapping them out from the VALUES
part of the pivot table and the values are extracted to somewhere else on the
sheet. However, in order for the macro work, I need to make sure that the
correct starting field is in the VALUES part of the pivot. Is there a way of
checking for what field is in the values part of the pivot table?
Alternatively, is there a way of clearing all fields from the values part?
Thanks!