Why do it that way. Filter the opposite, the records you don't want, then
delete them. Net result, the records you do want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"James.Shanahan" wrote
in message ...
Someone posted a query about deleting unwanted rows, I thought my
prayers had been answered but the old query was about filtering the
spreadsheet to gain objects you don't want, then deleting them (i.e.
deleting the filtered 'active' objects).

I have performed a filter to obtain records i want, now i want to
delete the other records that have been hidden by the autofilter.

Thanks for your help, i'm new to VBA programming....