Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Macro specific table to generic table?
I have a statement below with "PivotTable5" - How do I make that a generic
pivot table to where it would work with any pivot highlighted? With ActiveSheet.PivotTables("PivotTable5").PivotFields ("Sum of Duration") .Calculation = xlPercentOfColumn .NumberFormat = "0%" -- Sue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Change a specific code to generic in VB macro | Excel Discussion (Misc queries) | |||
Does table have at least one row in Excel 2007? | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Creation of a Generic Macro | Excel Worksheet Functions |