|
为嘛下面多列转一列的没有问题,多行转一行的不行,急
----------------------------------------------------------
Sub 多列转一列()
Application.ScreenUpdating = False
ARR = Sheets(1).UsedRange
For J = 2 To UBound(ARR, 2)
Application.Intersect(Sheets(1).UsedRange, Columns(J)).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
Next J
Application.ScreenUpdating = True
End Sub
----------------------------------------------------------
Sub 多行转一行()
Application.ScreenUpdating = False
ARR = Sheets(1).UsedRange
For J = 2 To UBound(ARR, 1)
Application.Intersect(Sheets(1).UsedRange, Rows(J)).Copy Cells(1, Clolumns.Count).End(xlToLeft).Offset(0, 1)
Next J
Application.ScreenUpdating = True
End Sub
本帖最后由 qh8600 于 2015-5-17 09:21 编辑
zpy2 发表于 2015-5-17 05:23
可以吧 代码没错啊
Application.Intersect(Sheets(1).UsedRange, Rows(J)).Copy Cells(1, Clolumns.Count).End(xlToLeft).Offset(0, 1)
应该是columns
|
|