Execute macro for weekday

  • Thread starter Thread starter gholvad
  • Start date Start date
G

gholvad

Have been trying to execute macros on certain weekday have got it to
work to display me a message box based on an earlier thread but I would
like to add to cell c2 if its a monday and add some values to cell c5
if its a friday. is there a way to do that? thanks
 
Just add some code in the macro

If Weekday(Date) = 2 Then
'add C2
ElseIf Weeklday(Date) = 6 Then
'add C5
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro by day --- but only once per day 4
CF (If Formula Is ) placed into macro 1
Run macro on excel open if after certain time 3
Return the Date of a certain Day Each Month 2
How to fix the code for macro? 7
Search and Collect Date from Cell Containing a String with a Date 3
Next weekday ... 3
problem with date formula 5

Back
Top