Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logical Test for blank and then for score | Excel Worksheet Functions | |||
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 - To test for a Blank Sheet | Excel Programming |