TextToColumns using VBA without the prompt

Joined
Jan 25, 2010
Messages
1
Reaction score
0
I have made a macro using VBA and I am using Text to columns to separate a couple columns of data. It works great however there is a prompt that asks if I would like to continue each time i use the command.

I was wondering if there was a way to bypass the prompt?

here is the code I am using.

textColOne.TextToColumns textColTwo, DataType:=xlDelimited, Other:=True, OtherChar:=":"

textColOne and text ColTwo are range variables.

Thanks
 
Back
Top