I keep getting an compile error with the script below. Am I doing something wrong?
Sub PivotTest1()
Dim pvt1 As PivotTable
Dim pf1 As String
Dim pf1_Name As String
Set pvt1 = ActiveSheet.PivotTables("PivotTable3")
pf1 = "(Annual) Adj Close"
pf1_Name = "Annual Close"...