UDF: Celll Row Number

[Arun]

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!

 

[Bob Phillips]

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