|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Private Sub CommandButton1_Click()
- Dim arr(), n&, i&, j&
- n = Application.CountA(Sheet1.Range("a7:a13"))
- ReDim arr(1 To n, 1 To 10)
- x = 1 * Range("t3")
- For i = 1 To n
- arr(i, 1) = x
- arr(i, 2) = Range("u4")
- arr(i, 3) = Range("c4")
- arr(i, 4) = Cells(i + 6, 1)
- arr(i, 5) = Cells(i + 6, 4)
- arr(i, 6) = Cells(i + 6, 8)
- arr(i, 7) = Cells(i + 6, 11)
- arr(i, 8) = Cells(i + 6, 13)
- arr(i, 9) = Cells(i + 6, 27)
- arr(i, 10) = Range("t17")
- Next
- With Sheets("数据库")
- i = .Range("a65536").End(3).Row
- If .Cells(i, 1) = x Then
- MsgBox "“NO:" & x & "”的收款收据已存在,请检查!"
- Exit Sub
- End If
- .Cells(i + 1, 1).Resize(n, 10) = arr
- .Cells(i + 1, 1).Resize(n, 10).Borders.LineStyle = xlContinuous
- End With
- MsgBox ("OK!保存成功!")
- End Sub
复制代码 |
|