|
Sub 打印()
Dim i%, k%, arr, brr()
arr = Sheet2.Range("a2").CurrentRegion
On Error Resume Next
For i = 1 To UBound(arr)
If arr(i, 1) = Sheet1.Range("d2") Then
k = k + 1
ReDim Preserve brr(1 To 3, 1 To k)
brr(1, k) = k
brr(2, k) = arr(i, 2)
brr(3, k) = arr(i, 3)
End If
Next
Sheet1.Range("a4:e" & Cells(Rows.Count, 1).End(xlUp).Row).Clear '清空数据
Sheet1.Range("a4").Resize(UBound(brr, 2), UBound(brr)) = Application.Transpose(brr) '删除行
If UBound(brr, 2) < 26 Then
With Sheet1.Range("a30")
.Value = "合计"
.Offset(0, 2) = Application.Sum(Range("c2:c" & Cells(Rows.Count, 1).End(xlUp).Row - 1))
.Offset(1, 0) = "盘点人:"
.Offset(1, 2) = "日期:"
End With
Sheet1.Range("a2:e31").Borders.LineStyle = xlContinuous
Else
With Sheet1.Range("a65536").End(xlUp)
.Offset(1, 0) = "合计"
.Offset(1, 2) = Application.Sum(Range("c2:c" & Cells(Rows.Count, 1).End(xlUp).Row - 1))
.Offset(2, 0) = "盘点人:"
.Offset(2, 2) = "日期:"
End With
End If
With Sheet1
.Range("a1").CurrentRegion.Borders.LineStyle = xlContinuous
.Cells.HorizontalAlignment = xlCenter
.PrintOut
End With
End Sub
|
|