|
本帖最后由 hasyh2008 于 2022-6-2 09:00 编辑
Sub TEST()
Dim K%, I%, Num As Single, Num2 As Single
With ActiveSheet
K = .Cells(Rows.Count, 1).End(3).Row
For I = 2 To K
If .Cells(I, "H") <> "√" Then
Rows(I).RowHeight = 0
Else
Num = Num + .Cells(I, 5)
End If
Num2 = Num2 + .Cells(I, 5)
Next
.Range("E1") = "金额(合计):" & vbCrLf & Num & "元"
.Range("A1:G" & K).PrintPreview '预览并打印a1-g列的有数据行
.Range("A2:A" & K).EntireRow.AutoFit
.Range("E1") = "金额(合计):" & vbCrLf & Num2 & "元"
End With
End Sub
|
|