Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of Formula
How can I get the cell address of the formula that calls a custom function?
Public Function Test(ByVal r As Range) As Integer 'How can I determine what cell contained the formula that called the function End Function For instance, if the SQRT(range) is called and the formula is on the same row as one of the values in the range, it will compute the SQRT of the number stored on on the same row. I want to be able to do the same type thing. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of Formula
Public Function Test(ByVal r As Range) As Integer
msgbox application.caller 'How can I determine what cell contained the formula that called the function Tommy wrote: How can I get the cell address of the formula that calls a custom function? Public Function Test(ByVal r As Range) As Integer 'How can I determine what cell contained the formula that called the function End Function For instance, if the SQRT(range) is called and the formula is on the same row as one of the values in the range, it will compute the SQRT of the number stored on on the same row. I want to be able to do the same type thing. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the results of the ADDRESS formula in another formula | Excel Worksheet Functions | |||
Formula without cell address | Excel Discussion (Misc queries) | |||
Cell Address in Formula | Excel Discussion (Misc queries) | |||
Help with Address Formula | Excel Worksheet Functions | |||
Need Address Formula | Excel Worksheet Functions |