When I run the following text-to-columns method :
I get a prompt asking me "do you want to replace the contents of the destination cells ?". Is there any way to prevent this prompt from appearing ?![]()
Selection.TextToColumns Destination:=Range("V1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ :="/", FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True
Bookmarks