Yes you can.

First you need to copy the 4 line function and paste it in VBA editor. See:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Gary's Student


"oscar" wrote:

Thank you for your reply.

Is it possible to use that macro in the formula bar?
I tryed with =qwerty(A1) and I got #NAME?

Thank you for your time

"Gary''s Student" wrote:

Yes:

Function qwerty(r As Range) As Integer
MsgBox (r.Offset(0, 1).Address)
qwerty = 0
End Function



--
Gary's Student


"oscar" wrote:

Is it possible to know the address of the cell that is passed as argument to
a macro function? I want to know this to compare to the cell next to the one
passed to the function.