Testing active cell

[Yogi39]

How can I determine if the active cell is in a particular range
EG : if activecell in range ("A1:C3&quot ?

 

[Zathras]

You could use this:

Sub test()
  If Intersect(ActiveCell, Range("A1:C3")) Is Nothing Then
    MsgBox "Not in A1:C3"
  Else
    MsgBox "In Range"
  End If
End Sub