Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. 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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A logical test in the If function for blank, i.e., If blank? | Excel Worksheet Functions | |||
Conditional formatting to test blank text cell | Excel Worksheet Functions | |||
test for not blank, use value in cell and set as variable | Excel Discussion (Misc queries) | |||
Excel VBA Test For Blank Cell | Excel Programming | |||
Excel - To test for a Blank Sheet | Excel Programming |