Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
null value cell
Hi All,
Im attempting to create code to evaluating cell content. However, I am having a little trouble creating code to recognize cells having no value or null cell. Heres the code. Sub testcode() Sheets("DISPLAY").Select If Range("O9").Value < Null Then If Range("O9").Value < "FirstBoxDisputesRelated" Then DropDownBox = Range("O9").Text ActiveSheet.Shapes(DropDownBox).Select Selection.Cut End If End If End Sub What changes are required to recognize cell O9 when the value does not equal null? Thanks Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
null value cell
Instead of testing for Null, test for an empty string. E.g.,
If Range("O9").Value < "" Then -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Paul" wrote in message ... Hi All, I'm attempting to create code to evaluating cell content. However, I am having a little trouble creating code to recognize cells having no value or null cell. Here's the code. Sub testcode() Sheets("DISPLAY").Select If Range("O9").Value < Null Then If Range("O9").Value < "FirstBoxDisputesRelated" Then DropDownBox = Range("O9").Text ActiveSheet.Shapes(DropDownBox).Select Selection.Cut End If End If End Sub What changes are required to recognize cell O9 when the value does not equal null? Thanks Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
null value cell
Thank You!!!!
"Chip Pearson" wrote: Instead of testing for Null, test for an empty string. E.g., If Range("O9").Value < "" Then -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Paul" wrote in message ... Hi All, I'm attempting to create code to evaluating cell content. However, I am having a little trouble creating code to recognize cells having no value or null cell. Here's the code. Sub testcode() Sheets("DISPLAY").Select If Range("O9").Value < Null Then If Range("O9").Value < "FirstBoxDisputesRelated" Then DropDownBox = Range("O9").Text ActiveSheet.Shapes(DropDownBox).Select Selection.Cut End If End If End Sub What changes are required to recognize cell O9 when the value does not equal null? Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell not null use that value | Excel Worksheet Functions | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
Sum a NULL cell | Excel Worksheet Functions | |||
cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Cell not null value? | Excel Programming |