Excel 2010 VBA: Last Row in Pivot Table

ActiveSheet.PivotTables(1).TableRange1.Rows.Count

ActiveSheet.PivotTables(1).TableRange1.Row + ActiveSheet.PivotTables(1).TableRange1.Rows.Count

Hi All

I am trying to assign the last row of a Pivot Table to a variable.

I have tried the two statements above in the immediate window that I found on another thread, but it is not always referencing the last row.

Help!