This is probably a simple one, I have a selection of data that is ever increasing. I want some code that will recoginse if certain cell contain the word "Blank" if they do then I want it to delete those rows.
Chitosunday is correct in that a Range called "celnotblank" could be searched and those rows that apply will be deleted.
However, ther are a whole bunch of ways to select a range of cells that would be searched for the offending word. Chitosundays' way would only search cells within the Named Range. Another way would be to allow you to select the range you wish to search, like so:
Dim i As String
Dim j As String
Dim xlWSheet As WorkSheet
Set xlWSheet = ActiveSheet
i = ActiveWindow.RangeSelection.Address
For Each c in xlWSheet.Range(i).Cells
j = c.Value
If LCase(j) = "blank" Then