K
Kevryl
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
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