MSG Box - Stop Macro
 

Why not just use the else criteria...

lastrow = Application.ActiveCell.Row
If Range("k" & lastrow) = "Atty Fees" Then
MsgBox "Complete Benefit Calc 1st"
activecell.offset(1,0).select
else
'Normal execution...
end if



--
HTH...

Jim Thomlinson


"Janet H" wrote:

I have this line in my code -

lastrow = Application.ActiveCell.Row
If Range("k" & lastrow) = "Atty Fees" Then MsgBox "Complete Benefit Calc
1st"

If the criteria causes the MsgBox to appear, I want to stop the process and
return the user to lastrow + 1

What do I add to the end of the MsgBox line to do this?

Thanks!