Adv. Filter & Worksheet Change Event
 

Morning all.
I have the below code in a sheet, to action an advance
filter whenever cell F12 is changed. However the below
code error's out. (Error 1004)
Would it be possible to get some help in fixing this code?
Many thanks.
Cheers, Russell.

Private Sub Worksheet_Change(ByVal F12 As Range)
Range("Suppliers").Range("B4:B20000").AdvancedFilt er
Action:=xlFilterCopy, _
CriteriaRange:=Range("J11:J12"), CopyToRange:=
("K11"), Unique:=False
End Sub