Hi guys, I have an Excel file with defined macros that are opening specific PPT files. I'm looking for a VBA code that will run a specific macro base

[avi2go]

Hi guys,


I have an Excel file with defined macros that are opening specific PPT files.
I'm looking for a VBA code that will run a specific macro based on if certain cells are empty and other are not.


For example:
If cells B1 and B2 are empty but cell B3 isn't --> then run Macro1
If cells B1, B2 & B3 are empty but cell B4 isn't --> then run Macro2


Is it possible?
Many thanks!

 

[avi2go]

Actualy it's the other way around:

If cells B1 and B2 are NOT empty but cell B3 is empty --> then run Macro1
If cells B1, B2 & B3 are NOT empty but cell B4 is empty --> then run Macro2

 

[shg]

  If VarType(Range("B1").Value) <> vbEmpty And _
     VarType(Range("B2").Value) <> vbEmpty Then
    If VarType(Range("B3").Value) = vbEmpty Then
      Call Macro1
    ElseIf VarType(Range("B4").Value) = vbEmpty Then
      Call Macro2
    End If
  End If