J
JMay
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]
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]