View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Checking activecell value for NA

I have this IF then statement:

If ActiveCell.text = "RED" Or ActiveCell.text = "GREEN" Or ActiveCell.text =
"YELLOW" Or ActiveCell.text = "DONE" Then

....
END IF

What do I need to add to have it work if the activecell value is N/A?

Thanks,
Barb Reinhardt