[RESOLVED] Deleting non-visible rows

[MartinLiss]

Given a worksheet without headers that has been filtered, and given a range that refers to the column that has the filter, i know that the following will delete all the visible rows.

MyRange.Offset(-1, 0).Resize(.Rows.Count, 1).SpecialCells(xlCellTypeVisible).EntireRow.Delete

Is there some way to use Autofilter to also delete the non-visible row above each visible row?

[MartinLiss]

Resolved it in a different way.