View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sok Ki Hong Sok Ki Hong is offline
external usenet poster
 
Posts: 1
Default 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.