autofilter unique exept the first two

**ABBOV** · 08-11-2010, 06:06 PM

Hello,

I've got a small question, I use the autofilter function with vba in my sheet, this is the code.

Please Login or Register  to view this content.

The strange part is that whatever is filtered, the first two finds are the same, the rest of the autofilter's output is unique.

Anyone got an idea?

Thanks in advance.

ABBOV

See the attachment for an example.

**StephenR** · 08-11-2010, 06:15 PM

It's because AF needs a header, so if you insert a cell in C1 and put any old thing in it, it will work. Your code can be abbreviated slightly to:

Please Login or Register  to view this content.

**ABBOV** · 08-11-2010, 07:33 PM

Thanks for the quick response,

Your explanation sounds logical, also thanks for the quick remake of the code, Learned something new today. (and this day is only 1,5 hours old

)

Best regards

ABBOV