Autofilter Method of Range Class Failed

[goss]

Hi all,

Using Excel 2007.

I would like to delete all visible rows after autofilter, but my code is returning an error

Run-time error'1004':
AutoFilter method of Range class failed

Debug points here

Please Login or Register  to view this content.

I'm not sure why?
Full code below

thx
w

Please Login or Register  to view this content.

[goss]

Solved.

My biggest problem was that I did not have the correct range scoped in the original code
I was using C1:C, it should have been A1:C

Full revised code below
Thx
w

Please Login or Register  to view this content.