![]()
Public Sub DeleteCells() Range("a1").Select Do While ActiveCell.Value <> "" If Selection.Interior.ColorIndex = xlNone Then ActiveCell.EntireRow.Delete End If ActiveCell.Offset(1, 0).Select Loop End Sub
![]()
Public Sub DeleteCells() Range("a1").Select Do While ActiveCell.Value <> "" If Selection.Interior.ColorIndex = xlNone Then ActiveCell.EntireRow.Delete End If ActiveCell.Offset(1, 0).Select Loop End Sub
Last edited by VBA Noob; 08-25-2008 at 11:18 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks