Excel VBA Test For Blank Cell
 

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.

Range("CNT").Select
If isblank(CNT) Then '<-- This is the line I need help to
write correctly.
Selection.Offset (0, 5).Select

Thank you very much.
--
Rodney Getschman
Wisconsin VFW
.