Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Range Address, Row & Column numbers
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Range Address, Row & Column numbers
Edmund
You can always get members if you set the object to a variable, e.g Sub GetMembers Dim pvt as PivotTable Set pvt = Worksheets(1).PivotTables(1) pvt.[now members WILL list] End Sub I suspect you are looking for the TableRange1 or Table Range2 properties -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Edmund" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divide 2 pivot table numbers | Excel Worksheet Functions | |||
HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS | Excel Discussion (Misc queries) | |||
rounding off numbers gives an E in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table formatting numbers | Excel Worksheet Functions | |||
Constructing range address given row and col numbers of boundaries | Excel Worksheet Functions |