Autofiltering Macro using named ranges in Workbook

[Erin9903]

Hi everyone
I have a workbook where each week, I recreate the file and assign a quarter, year and fiscal week. My named ranges are as follows, all on my SETUP tab within the workbook


B2 = CFW = Current Fiscal Week = FW23
B3 = PFW = Prior Fiscal Week = FW21
B4 = PQTR = Pacing Quarter = ex. Q2
B5 = PYR = Pacing Year = 2018

I am trying to write a macro to autofilter my base data based on the PQTR, which is all in a data table called Template.

ActiveSheet.ListObjects("Template").Range.AutoFilter Field:=3, Criteria1:= _
        Sheets(Setup).Range("B4").value

I am getting an error with this. Any suggestions? Thanks!

 

[Roger Govier]

You haven't said what the error message is.
Does B4 on Sheet Setup contain Q2?
Does Q2 exists in any cell within the third column of the table Template?