Get cell address from macro function argument

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Yes:

Function qwerty(r As Range) As Integer
MsgBox (r.Offset(0, 1).Address)
qwerty = 0
End Function
 
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
 
Back
Top