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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top