Hey Gents,
I have the following issue
Worksheets("Raw Data for PR Dist").Range("A6:AL1048550").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange _
:=Sheets("Advanced Filter sheet").Range("B10:D174"), Unique:=False
i want the criteria " Range("B10:D174) " to read up to the last...