Using code posted by Peter_SSs yesterday I am attempting to get into the variable TOTPT the total value generated by a pivot table.
The code I have so far locates the cell (column and row) containing the value, however I cannot fathom how to get the value into the variable.
My code is: totpt = Range("LastColumn & Chr(10) & pivotlastrow").Select
LastColumn ="AR", Pivotlastrow =730
Please help
The code I have so far locates the cell (column and row) containing the value, however I cannot fathom how to get the value into the variable.
My code is: totpt = Range("LastColumn & Chr(10) & pivotlastrow").Select
LastColumn ="AR", Pivotlastrow =730
Please help