View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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!