View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Janet H[_2_] Janet H[_2_] is offline
external usenet poster
 
Posts: 16
Default MSG Box - Stop Macro

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!