Code to not run rest of macro if specific value in cell, error check

[Craig13_13]

Hi all

I have a cell built into my spreadsheet that serves as an error check (i.e. returns the word 'ERROR' if certain criteria are fulfilled on the spreadsheet).
I'm trying to write something into a Macro that will check this cell and not allow it to run if it states ERROR, returning a dialog box to notify this, is this possible?

Thanks in advance
Craig

 

[ChrisR]

Hi Craig,

I think you just need something simple like this. This will check the active cell...........So if this is not where you want it to check for error you will need to change this to suit

Sub ERRORCHECK()
If ActiveCell = "ERROR" Then
MsgBox "Error found. Exiting Macro"
Exit Sub
Else
MsgBox "MACRO WILL RUN OK"
'Enter existing macro code here
End If
End Sub

 

[Craig13_13]

Spot on!

Thanks very much Chris!