ExcelBanter - Null and Nothing condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Null and Nothing condition (https://www.excelbanter.com/excel-programming/274108-null-nothing-condition.html)

Sok Ki Hong

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.

Tom Ogilvy

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.

All times are GMT +1. The time now is 01:23 PM.