How do I determine a Function's callling Row Number.
Same as the last time you asked.
dim rng as Range
set rng = application.Caller
myrow = rng.row
--
Regards,
Tom Ogilvy
"Mac Lingo" wrote in message
link.net...
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
|