| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test if Cell is within Range (name)
I have a dynamic range (meaning the size will change) that is defined with a name. How can I easily test if an active cell is within that range? Thanks, 'expl: 'Range B2:Z15 (name "TESTRANGE") 'ActiveCell D4 'Test if D4 is within "TESTRANGE" ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I test for nulls within a range without specifying each ce | Excel Discussion (Misc queries) | |||
| Test within a range? | Excel Worksheet Functions | |||
| Test if CELL is in RANGE | Excel Worksheet Functions | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| logical test - within a range | Excel Worksheet Functions | |||
![goepf[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
