This should do it

Function RowOffset(rng1 As Range)
RowOffset = Application.Caller.Row - rng1.Row
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Egon" <jhalljr@gmail.com> wrote in message
news:1132678547.750785.52000@g47g2000cwa.googlegroups.com...
> I have two cells in a custom fuction.
>
> A9 ' For example
> The cell the function is in.
>
> A9 is passed to the function as a arguement.
>
> What I need to do is find the ROW offset of A9 and the cell the
> function is in.
>
> Can anyone help with this? I'm going to have to do the same thing with
> some Column offsets as well, but I think if I can get over the ROW
> offset problem, I think I can get around the Column offset as it should
> be similar.
>
> TIA
> J. Hall
>