How do I find which cell called a function?

[TL]

I have a user function called from a cell on the
spreadsheet which draws a line based on input from
ajoining cells.

The cell content looks like this:

=LinkDraw(x1,y1,x2,y2)

The value of the cell is just 0 for fail and 1 for success.

Works great, but now I need to be able to determine, from
within the LinkDraw() function, which cell called the
function.

Ideally, I would like to do this without any kludgy
nonsense like feeding the answer as an input variable:

=LinkDraw(x1,y1,x2,y2,CELL(row),CELL(col)) <-Yucky.

Any suggestions?
-TL

 

[J.E. McGimpsey]

Take a look at the Application.Caller property in Help.

 

[Alan Beban]

If Type Of Application.Caller Is Range Then
Msgbox Application.Caller.Address
End if

Alan Beban

 

[TL]

That works -- Thanks!
-TL

-----Original Message-----
If Type Of Application.Caller Is Range Then
Msgbox Application.Caller.Address
End if

Alan Beban


.