Nice. Figured there was something like that out there.


On Jul 16, 12:30 pm, "Don Guillett" wrote:
right click sheet tabview codeinsert this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("ifrng")) Is Nothing Then MsgBox "Yes"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

ps.com...

I have a named range and when a user selects a cell I want to see if
their selection is inside that range. Any ideas?