Active cell is within a specific range

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

I need to check to see if the activecell is within a
particular range. Lets say I want to see if the active
cell is within range "A1:F20". How do I do this?


Thanks
Todd Huttenstine
 
Todd,

Use the Intersect method. For example,

If Application.Intersect(ActiveCell,Range("A1:F20") Is Nothing
Then
' active cell not in range
Else
' active cell in range
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

VBA set thick borders around non empty cells in range 0
Populating a range of empty cells with usernames 4
Copy the contents of a range of cells to a single comment(indicator)? 2
Activate Find Results 4
loop to copy paste 3
Sub to copy only result lines within formula range, omit null string lines 4
VBA: How do I find a value within a selected range? 2
Referring to a cell without using Offset 5

Back
Top