Hi.
Im sure this is a very common problem.
I tried searching for it but I havent found anything that solves this for me.
Here is the code Im using:
Sub InterfaceAutoFilterProspectID()
' Engages AutoFilter with cell M3 in -ForMacros2- as Criteria1
Sheets("-ForMacros2-").Select
Dim cRit As String
cRit = Sheets("-ForMacros2-").Range("M3").Value
Selection.AutoFilter Field:=3, Criteria1:=cRit
End Sub
I have a listbox with some values in it which is linked to the cell M3.
The idea is to AutoFilter with the value selected in the listbox as Criteria1.
The AutoFilter does actually work. The list is filtered with the value selected but I still get the "AutoFilter method of Range class failed" error message.
Any ideas?
Bookmarks