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
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