Prev: Force PasteSpecialValues in Excel 2007
Next: To get the same header,footer and sheet titles across multiple sheets of a workbook.
From: JMay on 23 Feb 2010 20:00
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]
 | 
Pages: 1
Prev: Force PasteSpecialValues in Excel 2007
Next: To get the same header,footer and sheet titles across multiple sheets of a workbook.