This should be simple but...
Jeff
Something like this should work. Cells with the default background (pattern?)
have the PatternColorIndex of -4142, not my first guess but I was able to use
the immediate pane to find out). Select the applicable rows and run this
simple code.
Sub test()
Dim cl As Range
For Each cl In Selection
If Not (cl.Interior.PatternColorIndex = -4142) Then cl.EntireRow.Delete
Next cl
End Sub
Good luck.
Ken
Norfolk, Va
|