View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
AK AK is offline
external usenet poster
 
Posts: 56
Default If statement to stop macro

How do you get a Msg box to show up with "Comments"?

Thanks

"Harald Staff" wrote:

Yes you can.

If Range("A1").Value = 0 Then Exit Sub

HTH. Best wishes Harald

"AK" skrev i melding
...
Running a macro to basically rearrange data. However if there is no data,

i
receive and error.

Can I use an If statement to check a cell and if blank or "0" to stop

macro?

Thanks in advance