excel打印预览和打印时自动隐藏空白行!怎么写代码呢?

2025-04-13 09:33:47
推荐回答(1个)
回答1:

Private Sub workbook_beforeprint(cannel As Boolean)
Dim k As Integer
a = Range("h5555").End(xlUp).Row
For k = 1 To a
If Cells(k, 8) = "" Then
Rows(k & ":" & k).Select
Selection.RowHeight = 4.5
End If
Next
End Sub

试试看