Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null and Nothing condition
I am trying to set up a condition, where if the active
cell is null, it will go through a set of commands. Currently, I've tried if ActiveCell is Null lines of commands and if ActiveCell is Nothing lines of commands neither one seems to work however, can anyone shine any light on this? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null and Nothing condition
If isempty(activeCell) then
Regards, Tom Ogilvy "Sok Ki Hong" wrote in message ... I am trying to set up a condition, where if the active cell is null, it will go through a set of commands. Currently, I've tried if ActiveCell is Null lines of commands and if ActiveCell is Nothing lines of commands neither one seems to work however, can anyone shine any light on this? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
cell value based on null/not null in another cell | Excel Worksheet Functions |