Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Calling Cell
One way:
Public Function WhoAmI() As String If TypeName(Application.Caller) = "Range" Then _ WhoAmI = Application.Caller.Address(0, 0) End Function In article , "John H W" wrote: I know that you can call or find out the the active cell when in a function/sub, but I can not find out if there is a way to find out the CALLING cell (without out passing the value as a parameter). Thanks, John H W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling the contents of a random cell | Excel Worksheet Functions | |||
VLookup only calling one cell | Excel Discussion (Misc queries) | |||
Referencing Calling Cell | Excel Programming | |||
Referencing Calling Cell | Excel Programming | |||
calling VBA functions from a cell | Excel Programming |