Excel VBA Test For Blank Cell

T

Tod

Try this:

'If the length of the value in named range CNT is not zero
(there's something in it), do the deed. Otherwise do
nothing.
If Len(Range("CNT")) <> 0 Then
Range("CNT").Offset(0, 5).Select
End If
-----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