Is there any way to get the cell reference that a GetPivotData function is referring to? I have cells that equal GetPivotData from a Pivot Table on another sheet within the workbook. I want to be able to find a way to find the actual cell reference that the function is referring to. Is this at all possible? Thanks in advance.
Hi,
Just try typing in the reference.
E.g =Sheet4!A18
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks