Celll Row Number
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!
|