Reading a value into a variable

[Titian]

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

 

[Richard Schollar]

Hi Titian

In this example, you simply need to replace the Select with Value:

totpt = Range("LastColumn & Chr(10) & pivotlastrow").Value

Best regards

Richard

 

[Titian]

Thanks for your suggestion Richard.

I am getting an error at that line, "Method 'Range' of object '_Global' failed" and the result of testing TOTPT = Empty.

Any further suggestions?

Thanks again.

 

[Richard Schollar]

Sorry, should have reviewed what I typed a bit more carefully:

totpt = Range(LastColumn &  pivotlastrow).Value

Hopefully, this should work!

Richard

 

[Titian]

Thanks Richard - that's done the trick.