Excel VBA UDF Userdefined function - in which line is the function
 

Application.Caller.Row

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Eckhard" wrote in message
...
Hi,
how do I know in which line is my function?
I want to search in the three cell left of the function and therefore need
the row.

Thanks,
Eckhard