Hey Everyone,
I'm trying to write a custom formula that, based on the range between two dates, will highlight several cells to the right of it (one cell a week). Trouble is I do not know how to determine the cell's address. Do I HAVE TO include a reference to another cell in the variables i pass to the function? Or can is there some kind of "Target" cell reference that initiated the function as with the excel event routines (like Worksheet_SelectionChange)?
Thanks in advance!
Bookmarks