View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arun Arun is offline
external usenet poster
 
Posts: 103
Default UDF: Celll Row Number

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!