| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to know what cell called the custom VBA function?
I have developed a custom VBA function (foo). In a cell on the worksheet, I
add =Foo() . When Foo begins to run, I want to know what is the activeCell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to know what cell called the custom VBA function?
If you mean from which cell the function was called:
Dim r as Range set r = Application.Caller -- Gary''s Student "partyOfOne" wrote: I have developed a custom VBA function (foo). In a cell on the worksheet, I add =Foo() . When Foo begins to run, I want to know what is the activeCell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I know which cell a function is called from? | Excel Worksheet Functions | |||
| Custom Function being called when it shouldn't. | Excel Programming | |||
| Custom Function being called when it shouldn't. | Excel Programming | |||
| How can I find the last time a custom function is called ? | Excel Programming | |||
| Using a Custom Function - determining the row that called it | Excel Programming | |||
Hybrid Mode
