FInd the intersection

  • Hi,
    Is there any formula in excel which will give the address of the cell where a particular row of data intersects a particular column of data.



    Thanks,
    Malay



    eg.
    1
    1 1 1
    1

  • Re: FInd the intersection


    Hi Malay,


    Intersect method can be used in VB. It's something like this...


    [vba]
    Sub FindIntersection()
    If Intersect(Selection, Range("A10:D10")) Is Nothing Then
    MsgBox "Your Selection is not in the range"
    Else
    MsgBox "Your selection is within the range"
    End If
    End Sub


    [/vba]


    HTH.


    End Sub

  • Re: FInd the intersection


    Possibly, you could adapt the ADDRESS function...


    =ADDRESS(ROW(A1),COLUMN(A1))


    will return $A$1

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!