Thread: rt error 1004
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default rt error 1004

The below is a result of performing the Record Macro sys. But when I
run it again -- I get a r/t error 1004; Any ideas?
TIA,
Jim

Code:
Sub Macro3()
'
' Macro3 Macro
'

'
Range("A5").Select
ActiveSheet.PivotTables("PivotTable2").PivotFields ("Report Description
Caption" _
).PivotFilters.Add Type:=xlCaptionBeginsWith, Value1:="LGMC"
Range("A5").Select
End Sub
[/code]