How to know if a cell is in a range?

  • Thread starter Thread starter Casrlos A.
  • Start date Start date
C

Casrlos A.

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

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)
 
Thanks!!

Bob Phillips said:
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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF Statement 2
Help on an IF formula 3
Payment calculation 1
VBA set thick borders around non empty cells in range 0
Displaying a range based on a cell's contents 3
Locate text in range (multiple occurrences) and report other cell insame column? 10
Expand and collapse rows 7
Deleting specific information 3

Back
Top