Help on Marcos

A

abc

I'm using a macros here and here should have 4 columns.
But sometimes when 1 column without any figure.
It will show up 1 position is missing then the whole Pivot table can't be
calculated
How could I use the Pivot table with 1 missing figure. Thanks!


ActiveSheet.PivotTables("PivotTable2").NullString = "0"
Range("E4").Select
ActiveSheet.PivotTables("PivotTable2").PivotFields("PREV
Analsis").PivotItems( _
"New").Position = 1
ActiveSheet.PivotTables("PivotTable2").PivotFields("PREV
Analsis").PivotItems( _
"Uplift").Position = 2
ActiveSheet.PivotTables("PivotTable2").PivotFields("PREV
Analsis").PivotItems( _
"Flat").Position = 3
ActiveSheet.PivotTables("PivotTable2").PivotFields("PREV
Analsis").PivotItems( _
"Reduced").Position = 4
With ActiveSheet.PivotTables("PivotTable2").PivotFields(" AE")
.PivotItems("(blank)").Visible = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Playing back a Pivot Table macros 2
Pivot Table Help 1
REALLY NEED HELP ON THIS ONE. 5
VBA Pivot Table Error 1
Run-time error '1004' 5
Pivot Table Macro Error - almost solved 2
Pivot table - unwanted lines 2
Pivot Tables using VBA 0

Top