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!
|