Adv. Filter & Worksheet Change Event

R

Russell

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").AdvancedFilter
Action:=xlFilterCopy, _
CriteriaRange:=Range("J11:J12"), CopyToRange:=
("K11"), Unique:=False
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top