Detecting blank cells

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to write a routine that scans a column from
the top row to the last NON-BLANK row in that column. I
would then know at which row I should stop during by
subsequent manipulation of the data in the column of
interest.

I have been unable to find a way to test to see if a cell
is blank.

Is there a standard 'marker' (i.e. property of a cell)
which can be tested on the cell to determine if it is
devoid of any data (i.e. blank?)

Many Thanks
John
 
John

Sample code.

Sub DeleteRows_With_Zero()
findstring = "0"
Set b = Range("A:A").Find(What:=findstring, LookAt:=xlPart)
While Not (b Is Nothing)
b.EntireRow.Delete
Set b = Range("A:A").Find(What:=findstring, LookAt:=xlPart)
Wend
End Sub

Gord Dibben Excel MVP
 
Back
Top