View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lime Lime is offline
external usenet poster
 
Posts: 56
Default 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