自己录了一段宏,可以分列要的四行数据,请老师帮忙执行到每个工作表,另外要的四个数输入到汇总里.
有老师可以帮忙吗?
Sub Macro1()
Range("A10").Select
Selection.TextToColumns Destination:=Range("A10"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(5, 1), Array(53, 1), Array(59, 1), Array(66, 1), _
Array(70, 1), Array(80, 1), Array(90, 1), Array(100, 1), Array(108, 1), Array(113, 1), _
Array(121, 1), Array(129, 1), Array(137, 1)), TrailingMinusNumbers:=True
Range("A20").Select
Selection.TextToColumns Destination:=Range("A20"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(13, 1), Array(20, 1), Array(30, 1), Array(41, 1), _
Array(51, 1), Array(61, 1), Array(71, 1), Array(80, 1), Array(91, 1), Array(100, 1), _
Array(110, 1), Array(124, 1)), TrailingMinusNumbers:=True
Range("A26").Select
Selection.TextToColumns Destination:=Range("A26"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(10, 1), Array(21, 1), Array(30, 1), Array(41, 1), _
Array(51, 1), Array(61, 1), Array(71, 1), Array(80, 1), Array(91, 1), Array(100, 1), _
Array(103, 1), Array(116, 1), Array(127, 1), Array(136, 1)), TrailingMinusNumbers:=True
Range("A27").Select
Selection.TextToColumns Destination:=Range("A27"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(11, 1), Array(20, 1), Array(31, 1), Array(38, 1), _
Array(50, 1), Array(60, 1), Array(70, 1), Array(80, 1), Array(84, 1), Array(96, 1), _
Array(102, 1), Array(114, 1)), TrailingMinusNumbers:=True
End Sub
|