| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing if a cell is within a range
Hello all,
Is it possible to test if the active cell is within a certain range? I have a short list of categories, A36:A47, that I have given the range the name "CategoriesList". In the "Worksheet_SelectionChange" event, I want to test to see if the new active cell is within the CategoriesList range and if it is, set another cell on the worksheet to the same value as the active cell. If it is possible, please provide sample code. -- Thanks for any help anyone can provide, Conan Kelly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| testing range of cells for part of cell content | Excel Worksheet Functions | |||
| Testing a range for blanks | Excel Programming | |||
| testing whether the ActiveCell is in a given range | Excel Programming | |||
| Testing for content in Range | Excel Programming | |||
| Cell in Range Testing Function | Excel Programming | |||
Threaded Mode
