How to know if a cell is in a range?

[Casrlos A.]

Hello
I need to know if the cell D9 is in the range A7 - E20

Thanks

 

[Bob Phillips]

If Not Intersect(Range("D9"),Range("A7:E20")) Is Nothing Then
MsgBox "yes"
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Casrlos A.]

Thanks!!

If Not Intersect(Range("D9"),Range("A7:E20")) Is Nothing Then
MsgBox "yes"
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)