Get cell address from macro function argument

[oscar]

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.

 

[Gary''s Student]

Yes:

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

 

[oscar]

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]

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