Actually I think you've brilliantly simplified this script for me. I
didn't think of using indirect. Is there a way to script for excel
to follow these steps?

Find green cell
Return row number of green cell  as value in cell A1.

What I want is to color the cell that these formulas depend on
green. Move the green cell down one every month and have the cell A1
read this and return the new row # automatically as a value. Then I
can use the indirect formula  to cause all other formulas to auto
update.