|
- Sub a()
- Dim i&, j&, arr
- ReDim arr(1 To 11, 1 To Cells(390, Columns.Count).End(xlToLeft).Column)
- For i = 1 To UBound(arr, 2)
- arr(1, i) = Cells(390, i + 1)
- Next
- For j = 1 To 10
- For i = 1 To UBound(arr, 2)
- arr(j + 1, i) = arr(j, i) - 1
- If arr(j + 1, i) < 0 Then
- arr(j + 1, i) = 9
- End If
- Next
- Next
- [b394].Resize(UBound(arr), UBound(arr, 2)) = arr
- Range(Cells(394, 2), Cells(394, UBound(arr, 2))) = ""
- End Sub
复制代码 |
|