Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I an using a "Worksheet_Change" event. I want to test is "Target" is within
a range of Cells. My range is K7:P7. I tried: If (Target.Address(False, False) = Range("K7").Address(False, False) _ And Target.Address(False, False) <= Range("P7").Address(False, False)) When I click on a Cell within, K7 and P7, it get a true response. Good. But when I click on "M8", I also get a true response, Not good. What am I doing wrong? Thank you... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
testing range of cells for part of cell content | Excel Worksheet Functions | |||
IF Function testing a range and a cell | Excel Programming | |||
Testing Range Extent | Excel Programming | |||
Testing if a cell is within a range | Excel Programming | |||
Cell in Range Testing Function | Excel Programming |