Active cell is within a specific range
 

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

Active cell is within a specific range
 

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



"Todd Huttenstine" wrote in
message ...
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