View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
KRCowen KRCowen is offline
external usenet poster
 
Posts: 21
Default 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