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
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