Macro if criteria
Seems simple
If Range("A1").Value2 = "JOHN" And _
Range("B1").Value2 = "MARY" And _
Range("C1").Value2 = "" Then
Call Macro1
ElseRange("A1").Value2 = "JIM" And _
Range("B1").Value2 = "CRIS" And _
Range("C1").Value2 = "BOB" Then
Call Macro2
End If
--
HTH
Bob
"puiuluipui" wrote in message
...
Hi, i have two macros. (macro 1 and macro 2)
I need macro 1 to run if in A1 is "JOHN", in B1 is "MARY" and if C1 is
empty
; and macro 2 to run if in A1 is "JIM", in B1 is "CRIS" and in C1 is
"BOB".
Can this be done?
Thanks!
|