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?


2 replies

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
Excellent - many thanks! :)
0
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