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...