AutoFilter method of Range class failed - Yet autofilter works.

**Carlsbergen** · 09-25-2009, 08:58 AM

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:

Please Login or Register  to view this content.

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?

**pike** · 09-25-2009, 09:08 AM

try changing this line

Please Login or Register  to view this content.

**Carlsbergen** · 09-25-2009, 09:15 AM

Typical.. Just minutes after posting I find a solution

Sorry to have wasted your time pike.
I was just going to set the thread as SOLVED when I saw your post.

Anyway, the problem seems to have been that I was trying to autofilter the same list that populated the ListBox.
I changed it now so that the autofiltered list is in its own worksheet and now my original code works just fine.

Thanks anyway pike!!