View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.