Someone posted a query about deleting unwanted rows, I thought m
prayers had been answered but the old query was about filtering th
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 t
delete the other records that have been hidden by the autofilter

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

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....