Previous Topic Next Topic

Excel/VBA 2010 Continue with Macro

Solved/Closed
whitepanther - 10 Jul 2011 à 22:17
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 26 Jul 2011 à 00:56
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

Réponse 1 / 2
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
11 Jul 2011 à 00:06
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
whitepanther
25 Jul 2011 à 18:47
Excellent - many thanks! :)
Réponse 2 / 2
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
26 Jul 2011 à 00:56
your are most welcome

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response