S
ShannaD
Can someone help me figure out why my data that i am converting into
"general" form using text to columns is reverting back to what it started as
when the macro is done?
My code looks like this:
Range("B7").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.TextToColumns Destination:=Range("B7"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False,
FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Range("B3").Select
After it gets through this and I see it make the correct change, it changes
the data back to text.
Thanks for any help!
"general" form using text to columns is reverting back to what it started as
when the macro is done?
My code looks like this:
Range("B7").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.TextToColumns Destination:=Range("B7"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False,
FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Range("B3").Select
After it gets through this and I see it make the correct change, it changes
the data back to text.
Thanks for any help!