If macro

[afountas]

I have a macro (macro1) that needs be dynamic depending on a 2 cells values. I need code for the the following logic

Run Macro 1

but IF cell A1 = YES then RUN Macro1+ Macro2

but IF cell A1=YES & A2=YES then run Macro1+Macro3

 

[VoG]

Maybe like this

Sub amacro()
Call macro1
If Range("A1").Value = "YES" And Range("A2").Value = "YES" Then
    Call macro3
    Exit Sub
End If
If Range("A1").Value = "YES" Then Call macro2
End Sub

 

[Rick Rothstein]

Assuming Macro2 and Macro3 are the names of your macros, Macro1 should look something like this...

Sub Macro1
  '
  '   Put any code that Macro1 should be executing here,
  '   then call either Macro2 or Macro3 as follows.
  '
  If Range("A1").Value = "YES" Then
    If Range("A2").Value = "YES" Then
      Macro3
    Else
      Macro2
    End If
  End If
End Sub