ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running the second part of a macro only on Thursdays? (https://www.excelbanter.com/excel-programming/363586-re-running-second-part-macro-only-thursdays.html)

Lime

Running the second part of a macro only on Thursdays?
 
Hello All,
Thank you for you quick response...

Thanks,
Lime




"Tom Ogilvy" wrote:

if weekday(date,2) 5 then exit sub
if weekday(date,2) = 4 then ' Thursday
' code for macro 2
else
' code for macro 1
end if

--
Regards,
Tom Ogilvy


"Lime" wrote:

Hello,
I have a macro that I run Monday, Tuesday, Wednesday & Friday. Then I have a
second Macro that I run after I run the one mentioned above. My question can
I paste in the second macro in with the first but only have it run on
Thursdays??

Any help is greatly appreaciated,

Lime



All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com