dim wb as workbook
if typename(application.caller)="Range" then
set wb= application.caller.parent.parent
end if
sould do it :)
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
"Pierre Laporte" wrote:
I wrote a function that resides in an addin.
In the function I need to know what workbook is calling the function.
It's not the ActiveWorkbook, as the function may be called from a
Workbook that is dependant on the calling Workbook.
So the question is how do I determine the workbook that is calling the
function ?
Tks