VBA rookie here. I tried checking F1 & F2 for Help but cannot catch its
explanations for Pivot Table.

I'm stuck coz VBA does not seem to automatically list its members after the
priod.
"ActiveSheet.PivotTables(1).[no auto listing of members]"?

I tried:
"ActiveSheet.PivotTables(1).PivotFields(6).Dataran ge.Column" and ".Row". So
I found the address for the 1st cell of the ActiveSheet.PivotTables(1).

How can I get VBA to return:
(a) the last cell's address (or row or column) of ActiveSheet.PivotTables(1)
(b) the entire used range address of ActiveSheet.PivotTables(1)

Thanks a lot.
--
Edmund
(Using Excel XP)