ActiveCell within a Named Range

[Larrin]

Using the SelectionChanged event, I would like to check to see if the active cell is within a named range. If it is I will place a combo box in the cell and give it focus. Once the user makes a selection from the combo box I will place an asociated value in the active cell. The problem is I don't know how to tell if the active cell is wihtin the named range. Can someone tell me how to determine if the active cell is within a named range?

I haven't done any real Excel work since 1997 and I have forgotten most of what I once knew.

Thank You,
Larrin

 

[GlennUK]

Have a look at the Intersect method ( here's the help for it ):

This example selects the intersection of two named ranges, rg1 and rg2, on Sheet1. If the ranges don't intersect, the example displays a message.

Worksheets("Sheet1").Activate
Set isect = Application.Intersect(Range("rg1"), Range("rg2"))
If isect Is Nothing Then
MsgBox "Ranges do not intersect"
Else
isect.Select
End If

That should be enough to get you going.