| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Code - Simple Code Fix?
For an expert, this should be a simple fix.....
(at least I assume that it is....) The following code works, but only for one or two pivot tables on the worksheet. I have about 12 pivot tables on the same worksheet and I need them all to refer to A1 for the source data. What ammendments are needed? Sub Test() ActiveSheet.PivotTables(1).SourceData = Application.ConvertFormula([a1], xlA1, xlR1C1) End Sub Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
| Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names) | Excel Programming | |||
| Help with Pivot Table Code Please | Excel Programming | |||
| VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
| HELP! Code for Pivot Table | Excel Programming | |||
Threaded Mode
