is current cell within a named range
 

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

Thanks in advance!

is current cell within a named range
 

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

--


Gary


"Cinque Terra" wrote in message
...
Is there a clever way to test if the current cell is within a multi-column,
multi-row range?

Thanks in advance!