Syntax for multiple if statement
On Sat, 3 Dec 2005 14:39:02 -0800, "AndyRoo"
wrote:
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.
Sub foo()
If Range("B22") 0 And Range("A35") - Range("B22") = 3 Then
Range("A22").Select
End If
End Sub
Works fine here. There must be something else going on in your routines that
is not apparent from what you've posted.
--ron
|