Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |