I use the code below to find the Total cell in a pivot table.
Issue:
When a cell in the range is active; Selection.End(xlDown).Select, sometimes
selects the active cell, and sometimes selects the Total cell at the bottom
of the range which is correct.

How do I force the select to the bottom of the Pivot Table?

Range("A19").Select
Selection.End(xlToRight).Select
Selection.End(xlDown).Select
Selection.ShowDetail = True