Autofilter Method of Range Class Failed

**flindy87** · 08-02-2013, 06:02 AM

Hi, my code is returning a run-time error, cant seem to figure out why.

Please Login or Register  to view this content.

Bugging out on the highlighted line

**AB33** · 08-02-2013, 06:16 AM

.Range("a:m").

is wrong
May be
.Range("a1:m1").

**flindy87** · 08-02-2013, 06:34 AM

Tryed that as well! Doesn't work i'm afraid.

**AB33** · 08-02-2013, 06:45 AM

What range are you trying to filter?

May be

Please Login or Register  to view this content.

**flindy87** · 08-02-2013, 07:18 AM

Doesnt work either i'm afraid, it's nothing to do with the fact i've put an array in, is it?

**JosephP** · 08-02-2013, 07:34 AM

why use an array for one value?

Please Login or Register  to view this content.

**flindy87** · 08-02-2013, 11:47 AM

that doesnt work either i'm afraid.

**JosephP** · 08-02-2013, 11:49 AM

have you protected the sheet? do you have data in the first row?

**AB33** · 08-02-2013, 11:51 AM

Flindy87,
Please attach a sample.

Re: Autofilter Method of Range Class Failed