| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell address of function call
I have a function in my spreadsheet and I would like to know within that code
what cell the function is being called from, but I have no idea how to achieve this. Perhaps somebody here can point me in the right direction? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell address of function call
I've found it. Application.Caller.Address seems to do the job nicely.
"PatrickS" wrote: I have a function in my spreadsheet and I would like to know within that code what cell the function is being called from, but I have no idea how to achieve this. Perhaps somebody here can point me in the right direction? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i call a function to a cell? | Excel Worksheet Functions | |||
| Call a function when a cell changes | Excel Programming | |||
| Call VBA function from cell | Excel Programming | |||
| call a vb function from a cell | Excel Programming | |||
| How do I call a VBA function from a cell? | Excel Programming | |||
Linear Mode
