Thread: Excel 2007 Macro specific table to generic table?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
  
Posts: 285
Default 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
Reply With QuoteReply With Quote