Here's a simple question (I suspect the answer isn't..)

I want to trigger a macro to run at a specific month

Any ideas?

Thanks In Advance

Irma,

Quite simply ...

Sub Annual()
If Range("A1").Value = 3 Then
' 3 for March
Run ("MyMacro")
End If
End Sub

HTH
Carim

Use the OS scheduler.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"IRMA MENDOSA" wrote in message
...
Here's a simple question (I suspect the answer isn't..)

I want to trigger a macro to run at a specific month

Any ideas?

Thanks In Advance