| 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) |
| 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 | |||
Threaded Mode
