Whats wrong with this code?

[juju]

I use this code with a dropdown box on a spreadsheet to select months on a backend pivot table. it has worked great until I started to create a new dashboard - I just copied and pasted this code and changed the relevant fields: The name of the tab in the workbook with the data is "Summary", the pivot tables to change are "Message1" and "Message2", and the pivotfields being changed in both tables is the Month field... the error message is
"runtime error 1004: Application-defined or object-defined error"

Sub MessageMonthMacro()

Application.ScreenUpdating = False
'
' Internal dashboard month drop down box macro
'
    Sheets("Summary").PivotTables("Message1").PivotFields("Month").CurrentPage = Range("selMonth").Text
    Sheets("Summary").PivotTables("Message2").PivotFields("Month").CurrentPage = Range("selMonth").Text
    
Application.ScreenUpdating = True

End Sub

 

[juju]

I use this code with a dropdown box on a spreadsheet to select months on a backend pivot table. it has worked great until I started to create a new dashboard - I just copied and pasted this code and changed the relevant fields: The name of the tab in the workbook with the data is "Summary", the pivot tables to change are "Message1" and "Message2", and the pivotfields being changed in both tables is the Month field... the error message is
"runtime error 1004: Application-defined or object-defined error"

Sub MessageMonthMacro()

Application.ScreenUpdating = False
'
' Internal dashboard month drop down box macro
'
    Sheets("Summary").PivotTables("Message1").PivotFields("Month").CurrentPage = Range("selMonth").Text
    Sheets("Summary").PivotTables("Message2").PivotFields("Month").CurrentPage = Range("selMonth").Text
    
Application.ScreenUpdating = True

End Sub

Anyone? - I'd really appreciate some help with this .... thx!

 

[juju]

Anyone? - I'd really appreciate some help with this .... thx!

I am working on a project which is due today and I cant figure this one out! I will appreciate any insight I can get .. thanks ..