Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for a Cell within a range
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for a Cell within a range
IF Not Intersect(Target, Range("K7:P7") ) Is Nothing Then
'target is inside the range End If "Bruce A. Julseth" wrote in message ... 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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for a Cell within a range
Try the following (untestedP
Dim anyR as range on error resume next set anyr = intersect(target, range("K7:P7")) on error goto 0 if anyr is nothing then 'not in range else 'in range end if Its easier to do an Intersect and see if a cell is in a range than other approaches. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Bruce A. Julseth" wrote in message ... 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... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for a Cell within a range
Works like a "Champ"
Thanks... "Patrick Molloy" wrote in message ... IF Not Intersect(Target, Range("K7:P7") ) Is Nothing Then 'target is inside the range End If "Bruce A. Julseth" wrote in message ... 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... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for a Cell within a range
Hi,
Try one of these For a contiguous range If Not Intersect(Target, Range("A1:A10")) Is Nothing Then or a none contiguous range If Not Intersect(Target, Range("A1,C1,E1")) Is Nothing Then Mike "Bruce A. Julseth" wrote: 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... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |