Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Testing selection against named range
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Testing selection against named range
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Testing selection against named range
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Testing selection against named range
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ups.com... 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click sheet tabview codeinsert thisPrivate Sub
I have a problem where i could 10k named ranges. When i select an area of the sheet, i need to know which of those named ranges is selected. I have it working by looping over Workbook.names collection, but that takes 14 seconds. Any other way to ask excel what named ranges are intersecting the selection?
On Monday, July 16, 2007 12:19 PM BartParr wrote: 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? On Monday, July 16, 2007 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... On Monday, July 16, 2007 2:08 PM BartParr wrote: Nice. Figured there was something like that out there. On Monday, July 16, 2007 3:05 PM Don Guillett wrote: Glad to help -- Don Guillett Microsoft MVP Excel SalesAid Software |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
right click sheet tabview codeinsert thisPrivate Sub
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TESTING A RANGE OF CELLS | New Users to Excel | |||
TESTING A RANGE OF CELLS | Excel Worksheet Functions | |||
Testing a person's age to be within a range | Excel Worksheet Functions | |||
Selecting Multiple Columns in a Named Selection | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |