| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Set datarange for pivot table?
What is the correct way to update the data source for a pivot table? All I've
come up with is the following, but the new data range does not apply when the code runs. Is there a way to update the range directly wthout using the PivotTableWizard method? Is there a way to use "A1" referencing instead of "R1C1"? dim X as integer Sheets("ws1").PivotTableWizard SourceType:=xlDatabase, _ SourceData:="ws2!R1C1:R" & X & "C15" -- M Carman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reassignning datarange in a macro | Excel Discussion (Misc queries) | |||
| Pivot table datarange as list? | Excel Discussion (Misc queries) | |||
| Setting a datarange | Excel Discussion (Misc queries) | |||
| Datarange of source data | Excel Discussion (Misc queries) | |||
| Pivot DataRange BackColor | Excel Programming | |||
Threaded Mode
