Below is the Text To Column section of a macro I recorded. I do not understand the "Array" syntax and would sure appreciate a helping hand. Thanks !!
![]()
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlFixedWidth, _ OtherChar:="-", FieldInfo:=Array(Array(10, 19), Array(4, 1), Array(7, 9), Array(8, 1 _ ), Array(16, 9), Array(24, 9), Array(32, 1)), TrailingMinusNumbers:=True
Bookmarks