Thank you. It works great.

Jan

"Mike Fogleman" skrev i en meddelelse
m...
Function Test(arg As Range)
Test = arg.Address
End Function

Mike F

"Jan Kronsell" wrote in message
...
Hi NG!

Is there a way of capturing the cell address of an argument in a UDF in
stead of the value of the argument.

I have a UDF definition like

Function Test(arg)
...
End Function

when I use the function I type =test(A1) and i get the value of A1. But
what I like to captuire is the address A1

Is there any way to achieve this?

Jan