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

--


Gary


"Cinque Terra" <(E-Mail Removed)> wrote in message
news:83EE3A18-148D-4A58-9CC2-(E-Mail Removed)...
> Is there a clever way to test if the current cell is within a multi-column,
> multi-row range?
>
> Thanks in advance!