Call Macro If x 2 Q
Need a small bit of help, in calling a Macro (A below) if cell AE60,
if it is or isn't I still want to to test and run (B) below, do I have
the syntax of my End If's correct?
...........
(A) If Sheets("Sheet1").Range("AE6").Value 0 Then
Mail_New_Version 'run this sub macro
Call UncheckBoxes
Call DelAllCheckBoxes
(B) If Weekday(Sheets("Input").Range("BF1")) = vbMonday _
And Sheets("E-Mail").Range("AE6").Value = 0 Then
MailToBobWeekly '<------ run this sub macro
Call UncheckBoxes
Call DelAllCheckBoxes
End If
End if
End Sub
|