I copied this code from a search I did in this forum, and I modified the True/False conditions. Other than that, it's identical to what I found in my search. Of course, it doesn't work for me. But I'm not sure why.
Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=True, Comma:=True, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
What does the last line do? Help me understand, because I want to get better at this. I appreciate (very much) having the code, but I want to learn even more. Thanks in advance for all the help.
-gshock
Bookmarks