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