View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Lingo[_2_] Mac Lingo[_2_] is offline
external usenet poster
 
Posts: 53
Default How do I determine a Function's callling Row Number.

I need to know what ROW a Function is called from.

I am copying a Row with this function call in it to many Rows. The function
has to act on the data in the called row.

The ACTIVECELL pointer stays constant over all the calls, so that isn't
useful. I suppose I could generate a Column of Row Numbers and pass that in
the actual function call, ...

But isn't there a more elegant solution?

Thanks,
Mac Lingo