xla function called from sheet - how do I find source cell?

[Guest]

I have written a function in an xla addin which is called directly from a cell in the xls sheet
I wish to know within the xla precisely which cell in which sheet made that call to it.
Is there any way that I can get hold of this information?

 

[Jan Karel Pieterse]

Hi Ed,

I wish to know within the xla precisely which cell in which sheet made that call to it.

Application.Caller

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Guest]

fantastic
works great

Dim xlsName As Strin
Dim sheetName As Strin
Dim row As Intege
Dim column As Intege
Set from = Application.Calle

xlsName = from.Parent.Parent.Nam
sheetName = from.Parent.Nam
row = from.ro
column = from.colum

thank you