Sub is_it_in()
Dim r As Range
Set r = Range("print_area")
If Intersect(ActiveCell, r) Is Nothing Then
MsgBox ("its not in there")
Else
MsgBox ("its in there")
End If

End Sub

select the cell and run the macro
--
Gary's Student


"Vaughan" wrote:

Is it possible to test if a given cell falls within a range (or more
specifically if it falls within the 'print_area' named range)?