Hi, Below images show green error messages;
When I perform manually and record text to columns it fixes all the errors converting to currency. But when I run the macro, the macro runs without error but does not fix the green error..... Below is the code
Any ideas why the macro does not result in success?
Thanks
When I perform manually and record text to columns it fixes all the errors converting to currency. But when I run the macro, the macro runs without error but does not fix the green error..... Below is the code
VBA Code:
Columns("C:C").Select
Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Any ideas why the macro does not result in success?
Thanks