|
请老师帮忙看下,我想将区域sheet1,range(i6:q6)的值赋给sheet3,.range(a2:i2),向下添加,因为range(i6:q6)的值是随着k3的变化而变化,可是我的代码就是不能将变化了的数值赋给指定区域,请老师看看怎么办?
Sub Test1()
Dim i%, j%
With Sheet1
For i = 1 To 50
Cells(3, 9) = i
Sheet3.Cells(i + 1, 1) = Sheet1.Cells(6, 9).Value
Sheet3.Cells(i + 1, 2) = Sheet1.Cells(6, 10).Value
Sheet3.Cells(i + 1, 3) = Sheet1.Cells(6, 11).Value
Sheet3.Cells(i + 1, 4) = Sheet1.Cells(6, 12).Value
Sheet3.Cells(i + 1, 5) = Sheet1.Cells(6, 13).Value
Sheet3.Cells(i + 1, 6) = Sheet1.Cells(6, 14).Value
Sheet3.Cells(i + 1, 7) = Sheet1.Cells(6, 15).Value
Sheet3.Cells(i + 1, 8) = Sheet1.Cells(6, 16).Value
Sheet3.Cells(i + 1, 9) = Sheet1.Cells(6, 17).Value
Next i
End With
End Sub
测试一下,和你的代码效果是否一样 - Sub Macro1()
- arr = Sheet1.[i6:q6]
- Sheet3.[a2].Resize(50, UBound(arr, 2)) = arr
- End Sub
复制代码
|
|