View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andyroo Andyroo is offline
external usenet poster
 
Posts: 24
Default Syntax for multiple if statement

I keep tripping over with the following code. I have tried many variations
of it in my macro and they all fail:

If Range("B22") 0 And Range("A35") - Range("B22") = 3 Then
Range("A22").Select

The code sticks on the first line, so my If statement must be incorrectly
written somehow.

Any help gratefully received.