activecell column/row within range

[schanjc]

apologies if this has already been solved on this board, but I wasn't able to find anything like this after a searching around.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I've established whether my activecell intersects a range, but now I need to know the row and cell the active cell falls within the range.<o></o>
<o></o>
For Example Cell "C3" is my active cell<o></o>
named Range address is "B2:C10"<o></o>
<o></o>
the procedure should identify Row=2 column=2.<o></o>

 

[Norie]

Something like this perhaps.

Dim colWithinRng As Long
Dim rowWithinRng As Long
Dim strName As String
 
    strName = "Named"

    If Not Intersect(ActiveCell, Range(strName)) Is Nothing Then
        colWithinRng = ActiveCell.Column - Range(strName).Cells(1, 1).Column + 1
        rowWithinRng = ActiveCell.Row - Range(strName).Cells(1, 1).Row + 1
    End If
 
    MsgBox "Active cell is in row " & rowWithinRng & ", column " & colWithinRng & " of named range " & strName

 

[schanjc]

Thanks very very much...that did the trick.