is current cell within a named range

  • Thread starter Thread starter Cinque Terra
  • Start date Start date
C

Cinque Terra

Is there a clever way to test if the current cell is within a multi-column,
multi-row range?

Thanks in advance!
 
you can give this a try:

Sub test()
If Not Intersect(ActiveCell, Range("test")) Is Nothing Then
MsgBox ActiveCell.Address & " is within " & Range("test").Name
Else
'do nothing
End If
End Sub
 
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
List sorting and macros 3
Saving values from Multi-select List Box 2
Problem with a loop and column references 27
Pass activecell(.address?) as a range in a function parameter? 3
Post my named ranges in column A 10
Creating range name based on cell value. 6
Hide rows within range if B? = X 7

Back
Top