View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David C. David C. is offline
external usenet poster
 
Posts: 30
Default 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