View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bgkgmg bgkgmg is offline
external usenet poster
 
Posts: 40
Default Stop after IF Then

I'm running macro with many If Then statements. If Then applies to matching
invoice numbers and then moving info to row on another sheet. I am locking
cells that are involved on sheet2 and protecting worksheet after each one. I
would like macro to stop running after whichever If Then statement applies
first so other rows of If Then statements are not locked thus allowing me to
enter next statement.
I hope you understand question.
Thanks
Bobby