How to run a macro every March
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 |
How to run a macro every March
Irma,
Quite simply ... Sub Annual() If Range("A1").Value = 3 Then ' 3 for March Run ("MyMacro") End If End Sub HTH Carim |
How to run a macro every March
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 |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com