cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 168
I have a macro that references a pivottable for results. However since both fields sometimes might have same name I cannot tell by name if I am in first field or second field. When I hover over the cell it tells me the field being reported. Is there some way in vba to know the level/field that the row of the cell I am grabbing data from is?
I ussually just use classic pivot format to resolve but I love to figure out way to not rely on that format.
Any helps greeatly appreciated.
I ussually just use classic pivot format to resolve but I love to figure out way to not rely on that format.
Any helps greeatly appreciated.