Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute macro for weekday
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute macro for weekday
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) wrote in message ps.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
the macro don't execute | Excel Programming | |||
execute a macro | Excel Programming | |||
Execute Macro | Excel Discussion (Misc queries) | |||
Excel Macro Weekday / Today Function | Excel Programming |