row number within a named range

[Werner Rohrmoser]

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

 

[Gary''s Student]

Sub marine()
MsgBox (ActiveCell.Row - Range("Versions").Row + 1)
End Sub

 

[Don Guillett]

Maybe?

MsgBox ActiveCell.Row - Range("d5:d10").Cells(1).Row+1

 

[Mike H]

I would check the active cell is in the named range first

Sub sonic()
If Intersect(ActiveCell, Range("versions")) Is Nothing Then
MsgBox "The selected cell is not in the named range"
Else
With Range("versions")
irownumber = .Row
End With
MsgBox ActiveCell.Row - irownumber+1
End If
End Sub


Mike

 

[Werner Rohrmoser]

Thanks for all the suggestions.

Werner