View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Werner Rohrmoser Werner Rohrmoser is offline
external usenet poster
 
Posts: 88
Default 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