|
我正在尝试编写一个转置程序的VBA代码
Sub tt1()
Dim arr, i As Integer, brr
For i = 1 To 8
arr = Range("A" & i, "C" & i)
brr = Application.WorksheetFunction.Transpose(arr)
Sheet1.[h1].Offset(0, 1).Resize(8, 3) = brr
Next
End Sub
然而总是错误,我猜想应该是arr数组赋值这一块出了问题,因为带有变量i,无法像正常一样写成arr=range("A1:A3"),但是实在又不知道怎么改正,求助一下高人,谢谢
- Sub tt1()
- Dim arr, i As Integer, brr
- i = Cells(Rows.Count, 1).End(3).Row
- arr = Range("A1:C" & i)
- brr = Application.WorksheetFunction.Transpose(arr)
- Sheet1.[h1].Offset(0, 1).Resize(3, 8) = brr
- End Sub
复制代码
|
|