Previous Topic Next Topic

Excel/VBA 2010 Continue with Macro

Solved/Closed
whitepanther - Jul 10, 2011 at 10:17 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jul 26, 2011 at 12:56 AM
Hello,

Just a quick question I've got a Macro that runs perfectly except there are two times while it runs where it stops and asks you to click Ok to continue. Both times it's where we've asked it to perform a text to column function i.e. splitting information from one cell into several blank cells on the same row next to it.

I'm just wondering if there is a way to write the code so that it automatically carries on without having to Ok that message?


Related:

2 responses

Answer 1 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jul 11, 2011 at 12:06 AM
Use following lines in your code.

in the begining of the code. 
Application.DisplayAlerts = False



and at the end of the code 

Application.DisplayAlerts = True
1
whitepanther
Jul 25, 2011 at 06:47 PM
Excellent - many thanks! :)
0
Answer 2 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jul 26, 2011 at 12:56 AM
your are most welcome
0