B
BartParry
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?
their selection is inside that range. Any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
right click sheet tab>view code>insert this
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("ifrng")) Is Nothing Then MsgBox "Yes"
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("ifrng")) Is Nothing Then MsgBox "Yes"
End Sub
B
BartParry
Nice. Figured there was something like that out there.
D
Don Guillett
Glad to help
G
GS
Firstly, have 10k names is a really, really bad idea.
Secondly, having them workbook level is a really, really bad idea.
IMO, a better worksheet design would be more efficient...
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Secondly, having them workbook level is a really, really bad idea.
IMO, a better worksheet design would be more efficient...
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion