Excel VBA Test For Blank Cell

E

Esteban404

How 'bout

Range("CNT").Select
With Selection
If IsEmpty(.Value) Then
.Offset(0, 5).Select
End If
End With

-----Original Message-----
I'm new to this forum and believe I should have made my
initial post here, rather than under Applications.
I have a cell named, CNT. The possibility exists this
cell may contain either a label or a value. This cell
needs to be tested to determine whether it is a blank
cell. I
would like to use the ISBLANK function. Below are my
partially correct macro lines for doing this. I do not
know how to write the "if, then" procedure (portion)
correctly.
 
Top