Many thanks

The phrase "wood and trees" come to mind. Guess what with
"ActiveSheet.Paste" inserted, it works, unsurprisingly.

regards

Nick


"Dick Kusleika" wrote in message
...

' works fine to this point
' this next bit doesn't work - error is "No data to parse"
ActiveCell.Cut

Selection.End(xlUp).Select
Selection.End(xlToRight).Select
ActiveCell.Offset(0, 1).Select

Selection.TextToColumns Destination:=ActiveCell,
DataType:=xlFixedWidth,
_
FieldInfo:=Array(Array(0, 9), Array(25, 2), Array(34, 9),
Array(39,
4), Array(48, 2), _
Array(60, 1), Array(86, 1), Array(105, 1), Array(124, 9))


You Cut, but I don't see where you Paste.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.