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