My macro stops for confirmation - and I want to stop it

[hpl2001]

I am running a macro in Excel 2003. When the following code is executed ---


Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1))


--- a dialog box pops up asking me to verify the column move. How can I get it to stop asking and just do it?

TIA

Holly

 

[PHV]

Did you try to play with the Application.DisplayAlerts property ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MakeItSo]

Hi Holly,

just add

Application.DisplayAlerts=False

at the beginning of your macro and of course

Application.DisplayAlerts=True

at the end of it.

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[hpl2001]

That's exactly what I was looking for. Thank you!

H.