I can use the following format correctly outside of a macro, however when I record it and include it in a macro the format does not take effect. Range("X9").Select With ActiveSheet.PivotTables("PivotTable6").PivotFields("Sum of EXT PRCE ") .NumberFormat = "#,##0_);[Red](#,##0)" End With Any ideas why not?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Pivot Table number format in a Macro

Thread starter Titian
Start date Jun 22, 2011

Titian

Well-known Member

Jun 22, 2011

I can use the following format correctly outside of a macro, however when I record it and include it in a macro the format does not take effect.

Code:

Range("X9").Select
    With ActiveSheet.PivotTables("PivotTable6").PivotFields("Sum of EXT PRCE ")
        .NumberFormat = "#,##0_);[Red](#,##0)"
    End With

Any ideas why not?