i started with john walkenbach's "CALARRAY.xls".
i created a new wrksht in that wkbk with a larger version, formatted
to meet my needs, to be populated with other information, linked back
to john's calendar. i've got it all working to be updated every
month, except for one issue.....

a cell in each "block" of the day needs to display a message about a
medication. one day the person takes the medication, the next day she
doesn't. months are not always even numbered; therefore day #1 will
sometimes be "take meds" & sometimes "no meds", depending on what the
last day of the previous month was.

when i update the calendar for the next month, the first day of the
month moves, etc. i have the macro reading the last day of the month
BEFORE any changes are made, to find out if the last day was "take
meds" or "no meds". (the meds phrase should populate (correctly)
automatically.)

despite severe sledgehammering of idiotic amounts of ranges,
variables, and if-statements, i can't get it to work.

someone suggested a linear approach, with an entire year of "take
meds" & "no meds" set up; find the correct date & you've got the
correct phrase. i can't get my head around that one because the day
"numbers" showing are actual links to the other page, which are
generated from a huge formula, and only contain the # of the day, not
info month or year.

adding to the difficulty is that each day "block" actually consists of
several rows - not just one cell.

does anybody have any suggestions?

i can keep sledgehammering & i am cautiously optimistic that i can
FORCE the darn thing to work, but, as i said, it's going to be
ridiculously over-coded & warped.
:)
thanks in advance
susan

Don't quite understand the problem, but doing
=MOD(A1,2) etc. where A1 is the cell with the date
will give alternating 0 and 1. Then for example if 1 give med if 0 then
don't.

RBS

"Susan" wrote in message
ups.com...
i started with john walkenbach's "CALARRAY.xls".
i created a new wrksht in that wkbk with a larger version, formatted
to meet my needs, to be populated with other information, linked back
to john's calendar. i've got it all working to be updated every
month, except for one issue.....

a cell in each "block" of the day needs to display a message about a
medication. one day the person takes the medication, the next day she
doesn't. months are not always even numbered; therefore day #1 will
sometimes be "take meds" & sometimes "no meds", depending on what the
last day of the previous month was.

when i update the calendar for the next month, the first day of the
month moves, etc. i have the macro reading the last day of the month
BEFORE any changes are made, to find out if the last day was "take
meds" or "no meds". (the meds phrase should populate (correctly)
automatically.)

despite severe sledgehammering of idiotic amounts of ranges,
variables, and if-statements, i can't get it to work.

someone suggested a linear approach, with an entire year of "take
meds" & "no meds" set up; find the correct date & you've got the
correct phrase. i can't get my head around that one because the day
"numbers" showing are actual links to the other page, which are
generated from a huge formula, and only contain the # of the day, not
info month or year.

adding to the difficulty is that each day "block" actually consists of
several rows - not just one cell.

does anybody have any suggestions?

i can keep sledgehammering & i am cautiously optimistic that i can
FORCE the darn thing to work, but, as i said, it's going to be
ridiculously over-coded & warped.
:)
thanks in advance
susan

i don't know if ANYBODY will understand the problem, but i greatly
appreciate the suggestion!
thanks
susan


On May 2, 1:12 pm, "RB Smissaert"
wrote:
Don't quite understand the problem, but doing
=MOD(A1,2) etc. where A1 is the cell with the date
will give alternating 0 and 1. Then for example if 1 give med if 0 then
don't.

RBS

"Susan" wrote in message

ups.com...



i started with john walkenbach's "CALARRAY.xls".
i created a new wrksht in that wkbk with a larger version, formatted
to meet my needs, to be populated with other information, linked back
to john's calendar. i've got it all working to be updated every
month, except for one issue.....

a cell in each "block" of the day needs to display a message about a
medication. one day the person takes the medication, the next day she
doesn't. months are not always even numbered; therefore day #1 will
sometimes be "take meds" & sometimes "no meds", depending on what the
last day of the previous month was.

when i update the calendar for the next month, the first day of the
month moves, etc. i have the macro reading the last day of the month
BEFORE any changes are made, to find out if the last day was "take
meds" or "no meds". (the meds phrase should populate (correctly)
automatically.)

despite severe sledgehammering of idiotic amounts of ranges,
variables, and if-statements, i can't get it to work.

someone suggested a linear approach, with an entire year of "take
meds" & "no meds" set up; find the correct date & you've got the
correct phrase. i can't get my head around that one because the day
"numbers" showing are actual links to the other page, which are
generated from a huge formula, and only contain the # of the day, not
info month or year.

adding to the difficulty is that each day "block" actually consists of
several rows - not just one cell.

does anybody have any suggestions?

i can keep sledgehammering & i am cautiously optimistic that i can
FORCE the darn thing to work, but, as i said, it's going to be
ridiculously over-coded & warped.
:)
thanks in advance
susan- Hide quoted text -

- Show quoted text -