Run macro only it its in a selected range

[Garthygarth]

Hi there

I would like to run a macro if the cell pointer is in A1:A20 otherwise do not execute the rest of the macro

If the cell pointer is not in the range A1:A20 let the user know they must only run macro from A1:A20

Thanks

 

[DanteAmor]

Hi and welcome to MrExcel!

Try this:

Sub test()
  If Intersect(ActiveCell, Range("A1:A20")) Is Nothing Then
    MsgBox "You must run the macro from A1:A20"
    Exit Sub
  End If
  'continue the macro

End Sub