Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function 's cell caller
Hello,
I complety forgot how to do this, in a function (used as a formula in a cell) I need the adress of this cell how to know the row/col of the cell from wich the function is calculated ? thank you... -- David C. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
function 's cell caller
David, was it s'th like this?
if TypeName(application.caller)="Range" then set rngCaller=application.caller endif -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam David C. wrote : Hello, I complety forgot how to do this, in a function (used as a formula in a cell) I need the adress of this cell how to know the row/col of the cell from wich the function is calculated ? thank you... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
function 's cell caller
if TypeName(application.caller)="Range" then
set rngCaller=application.caller endif that's it except that I suppose the Type will always be a Range in my case (function called only from a formula in a cell ) Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.Caller | Excel Discussion (Misc queries) | |||
application.caller | Excel Programming | |||
Application.caller | Excel Programming | |||
Determining the immediate caller of a function | Excel Programming | |||
DDE and application.caller help | Excel Programming |