I'm writing a UDF function that requires the row number of the cell it's in.
How do I write a simple UDF that returns the row in which the function is
called from?

For example, the function RowFind below will return the value the CURSOR is
in.

Function RowFind
RowFind = ActiveCell.Row
End Function

Is there a an alternative to ActiveCell that will give the cell the FUNCTION
is in?

Thanks!

Function RowFind()
RowFind = Application.Caller.Row
End Function



--
__________________________________
HTH

Bob

"Arun" wrote in message
...
I'm writing a UDF function that requires the row number of the cell it's
in.
How do I write a simple UDF that returns the row in which the function is
called from?

For example, the function RowFind below will return the value the CURSOR
is
in.

Function RowFind
RowFind = ActiveCell.Row
End Function

Is there a an alternative to ActiveCell that will give the cell the
FUNCTION
is in?

Thanks!