Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting "CallingCell" In Function
Function who_called_me()
who_called_me = "" MsgBox (Application.Caller.Address) End Function -- Gary's Student "dec_obrien" wrote: Hi, I have a custom function that calculates the Date given various conditions. What I want to do is conditionally format the cell from where the function is called based on the day of the week calculated. It's like "ActiveCell" for the calling cell of the function but obviously ActiveCell will not be correct. I know I could pass the Cell Row/ Column in as arguments to teh function but this seems a bit messy if there an easier way of detecting this. Any ideas? -- dec_obrien ------------------------------------------------------------------------ dec_obrien's Profile: http://www.excelforum.com/member.php...o&userid=37705 View this thread: http://www.excelforum.com/showthread...hreadid=572994 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting "CallingCell" In Function
Thanks guys, Application.Caller.Address gets teh address of the cell but it won't change the format of the cell. -- dec_obrien ------------------------------------------------------------------------ dec_obrien's Profile: http://www.excelforum.com/member.php...o&userid=37705 View this thread: http://www.excelforum.com/showthread...hreadid=572994 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting "CallingCell" In Function
Correct.
Not possible with a worksheet function. NickHK "dec_obrien" wrote in message ... Thanks guys, Application.Caller.Address gets teh address of the cell but it won't change the format of the cell. -- dec_obrien ------------------------------------------------------------------------ dec_obrien's Profile: http://www.excelforum.com/member.php...o&userid=37705 View this thread: http://www.excelforum.com/showthread...hreadid=572994 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Detecting "CallingCell" In Function | Excel Programming | |||
Detecting if a value "fits" in a cell. | Excel Programming | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming |