Autofilter table depending on the date value from different sheet MACRO VBA

[mark692]

Hi sir as the title say, i want to filter a table depending on the value form different sheet


i have 2 sheets

Sheet 1 is where the cell is located with a date (Example cell is B1)

on

Sheet 2 i have a table with a column "DATE", i want to filter the column DATE, depending on the given date on sheet 1 B1


im using this code but i think its not working

ActiveSheet.ListObjects("Table8").Range.AutoFilter Field:=1, Criteria1:= range. B1

thanks in advance

 

[Fluff]

In that case, on your laptop in the VB Editor select Tools > references. Does anything show as "MISSING"?