row number within a named range
Hello,
I have a named range called "Versions" and it's located in "A10:A15".
When I select Range "A12" I get 12, when I use ActiveCell.Row.
What I'd like to know is the relative row in Range "Versions", which
would be 3.
What' s the syntax for it?
Thanks.
Regards
Werner
Excel XP SP3
Win XP SP1
|