Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wonder if someone can help me with a little code for inclusion in a macro?
It needs to do the following: If cell in column D on this row = "Sunday", perform Macro Sunday, otherwise execute macro Weekday Background info: I run an accounting system on a series of worksheets. The Cash Journal dynamically applies the week of the year and day of the week (based on the first date in the financial year) and conditionally formats rows accordingly to highlight weekends. Macros post the daily cashup sheet to the Cash Journal and General journal. I am combining them to operate both from the Cashup sheet and I need that macro to automatically avoid posting to a row in the Cash Journal that falls on Sunday. So it must makes a decision on the day and branch to an alternate macro on Sunday. (Both macros will be the same, except that Sunday will jump down 2 more rows (cash register inputs) than Weekday before recreating a range name that acts as a cursor locator.) Many thanks Kevryl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning macro buttons to macro code in another file | Excel Programming | |||
Write a branch to another macro | Excel Worksheet Functions | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Can I use code/macro to change code/macro in an existing file? | Excel Programming | |||
Macro code to remove a macro after it executes | Excel Programming |