View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Conditional testing

I have three cells, Cell1 is formatted as a text string, Cell2 a number and
Cell3 a date. If each contains a valid entry I want to do a block of code.
If any is empty, or if Cell2 or Cell3 contain text, I want to skip the code.
How do I write the If statement?

I appreciate your help, -John