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.
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
--
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks