| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting variable rows in a macro that creates a pivot table
I'm trying to create a multi-consolidation range pivot table via macro. Each time I run the macro the number of rows will be different The macro is currently hardcoding the source data into a fixed rang for column and row. See below. How do I change this to allow for a variable row selection? ActiveWorkbook.PivotCaches.Add(SourceType:=xlConso lidation SourceData:= _ Array("'EAG Original'!R1C2:R82C6")).CreatePivotTabl TableDestination:="", _ TableName:="PivotTable15 -- amarch0 ----------------------------------------------------------------------- amarch00's Profile: http://www.officehelp.in/member.php?userid=1 View this thread: http://www.officehelp.in/showthread.php?t=63290 Visit - http://www.officehelp.in/archive/index.php |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting the current month using a macro on a pivot table | Excel Discussion (Misc queries) | |||
| Selecting a range of values on pivot table attribute with a macro | Excel Discussion (Misc queries) | |||
| Pivot table creates blank table | Charts and Charting in Excel | |||
| Selecting next drop down item in pivot table with a macro ??? | Excel Programming | |||
| Selecting Rows in Pivot Table | Excel Programming | |||
Threaded Mode
