am trying to use the GETPIVOTDATA function to calculate the average for all
of the data field values {=AVERAGE(B10:N44)}. Is is possible to use the
GETPIVOTDATA in place of hardcoding the range? Thank you.
am trying to use the GETPIVOTDATA function to calculate the average for all
of the data field values {=AVERAGE(B10:N44)}. Is is possible to use the
GETPIVOTDATA in place of hardcoding the range? Thank you.
Hi,
Have you managed to solve this? I'm having the same problem, and hoping you could help me out if you have found the solution
thanks.
enrico, 2 things....
1st, please dont post your own question on some1 elses post, rather, start a new thread
2nd, that post is over 6 years old and it doesnt look it recieved any suggestions. i doubt the OP is watching it any more![]()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
oh i see.
Noted. Thanks FDibbins![]()
no problem![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks