Run Time Error '1004'

galkej · #1 02-03-2014, 06:39 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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