Autofilter - Delete Visible Rows without deleting the header row

[easty]

Hi there,

just a quick question.......

i want to be able to delete the visible data using autofilter, but I want to keep the header row.

I'm using the below code, but it deletes the header row........any thoughts??

Please Login or Register  to view this content.

Thanks for your help

Easty

[teylyn]

moved to Programming forum.

easty, please select the correct forum before hitting the "New thread" button.