From which cell is my VBA function called ?

[Helge V. Larsen]

I have a VBA function that is called from many cells in several worksheets
in my workbook. The function performs some error trapping (data checking)
and gives a message if an error is found.

However, I need to retrieve information on from where the erroneous call of
the function is placed (sheet and cell).

Is it possible to get this information by VBA ?

 

[Andy Pope]

Hi,

Can you get the information you need from the activecell object?

Msgbox Activecell.parent.name & "!" & activecell.address

Cheers
Andy

 

[Helge V. Larsen]

I have also asked http://www.tek-tips.com/
which gave the good answer "Take a look at Application.Call" - so I just use
"Application.Caller.Address(False, False, xlA1, True)".
Helge