Very new to macro, couldn't understand why I got compile error (syntax error) with the following:
Sub TextColumn()
Columns("A:A").Select
FieldInfo:=Array(Array(0, 1), Array(7, 1), Array(41, 1), Array(52, 1), Array(58, 1), _
Array(72, 1), Array(80, 1), Array(88, 1), Array(96, 1), Array(105, 1), Array(116, 1)), _
TrailingMinusNumbers :=True
End Sub
I originally had this:
Sub TextColumn()
Columns("A:A").Select
FieldInfo:=Array(Array(0, 1), Array(7, 1), Array(41, 1), Array(52, 1), Array(58, 1), Array(72, 1), Array(80, 1), Array(88, 1), Array(96, 1), Array(105, 1), Array(116, 1)), TrailingMinusNumbers :=True
End Sub
Got the same error, however.
This is probably some stupid mistake and obvious to most of you, so I'm sorry to waste your time, but would appreciate your help.
Sub TextColumn()
Columns("A:A").Select
FieldInfo:=Array(Array(0, 1), Array(7, 1), Array(41, 1), Array(52, 1), Array(58, 1), _
Array(72, 1), Array(80, 1), Array(88, 1), Array(96, 1), Array(105, 1), Array(116, 1)), _
TrailingMinusNumbers :=True
End Sub
I originally had this:
Sub TextColumn()
Columns("A:A").Select
FieldInfo:=Array(Array(0, 1), Array(7, 1), Array(41, 1), Array(52, 1), Array(58, 1), Array(72, 1), Array(80, 1), Array(88, 1), Array(96, 1), Array(105, 1), Array(116, 1)), TrailingMinusNumbers :=True
End Sub
Got the same error, however.
This is probably some stupid mistake and obvious to most of you, so I'm sorry to waste your time, but would appreciate your help.