#1
|
|||
|
|||
Run Time Error '1004'
My error is: Unable to get PivtoItems property of the PivotField Class.
My code is below. I am trying to make certain fields within a Pivot table visible/invisible. I am trying to do this within a Macro. Is this possible? With ActiveSheet.PivotTables("PivotTable3").PivotFields ("Month and Year") .PivotItems("(blank)").Visible = True .PivotItems("(blank)").Visible = True End With With ActiveSheet.PivotTables("PivotTable3").PivotFields ("Month and Year") .PivotItems("(blank)").Visible = False .PivotItems("(blank)").Visible = False End With Sheets("SCORE").Select Range("B1").Select End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Run-time error '1004': Document not saved. The document may be open... | doctor_who12 | Excel Programming | 1 | 01-22-2014 04:47 PM |
paste fails error 1004 in VBA Excel 2010 | mikec | Excel Programming | 17 | 05-08-2013 03:11 PM |
Run time error 1004 | yonasan | Excel Programming | 3 | 06-12-2012 11:08 PM |
runtime error 1004 | gbaker | Excel Programming | 11 | 06-06-2012 05:23 AM |
Word Visual Basic error - run time error 504 | crazymorton | Word | 11 | 01-13-2012 04:32 AM |