|
发表于 2015-10-12 13:26
|
显示全部楼层
本楼为最佳答案
- Sub 保存()
- arr = [b5:I7]
- Dim brr(1 To 3, 1 To 9)
- For i = 1 To 3
- If Len(arr(i, 1)) > 0 Then
- n = n + 1
- brr(n, 1) = [c3]: brr(n, 2) = [I1]: brr(n, 3) = [d2]
- brr(n, 4) = arr(i, 1)
- For j = 5 To 9
- brr(n, j) = arr(i, j - 1)
- Next
- End If
- Next
- If n > 0 Then Sheet2.[a65536].End(3).Offset(1).Resize(n, 9) = brr: MsgBox n & "条记录已保存!"
- End Sub
- Sub 新建()
- dh = [I1]
- x = Format(Val(Right(dh, 3)) + 1, "000")
- dh = Left(dh, Len(dh) - 3) & x
- [I1] = dh
- [b5:g7].ClearContents
- End Sub
- Sub 打印()
- ActiveSheet.PrintOut
- End Sub
复制代码 |
|