Custom Formula and the Refering Cell's Address
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!
Last edited by treyr; 06-07-2010 at 02:24 PM.
Additionally, I tried to just add a reference to a cell I want to highlight. But it results in an #VALUE error. Weird...
Please Login or Register to view this content.
Not sure I follow, but this might start you off:
E.g.Please Login or Register to view this content.
and type =Refer() in a cell.Please Login or Register to view this content.
Hey,
Thanks for the quick response. And that is exactly what I was looking for! But now I have the same problem as when I specifically passed a target cell. It produces a #VALUE! error when I try to change the fill color of a cell. Is there any reason why this would not be allowed?
Please Login or Register to view this content.
You cannot format cells from a UDF.
Remember what the dormouse said
Feed your head
Hum...
Good to know, Thanks Romper, Thanks Stephen!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks