通過改變RowHeight和ColumnWidth值,VBA可以調節行高和列寬。
妳在A列追加壹些數據,或者在第壹行的最右面追加些數據,再執行test1程序看打印預覽是否還是自動調整到壹個整頁:
Sub sss()
'非空行數為m,非空列數為n
m = [A65535].End(xlUp).Row
n = [iv1].End(xlToLeft).Column
Rows("1:" & m).RowHeight = 720 / m
Range(Cells(1, 1), Cells(1, n)).ColumnWidth = 83 / n
End Sub
2、不建議妳用上面那個改變行高和列寬的方法,因為字體妳還要編程序進行改變。簡單的辦法就是把要打印的區域用VBA設置成整頁.比如test2這個樣子:
Sub test2()
m = [A65535].End(xlUp).Row
n = [iv1].End(xlToLeft).Column
With ActiveSheet.PageSetup
.PrintArea = ActiveSheet.Range(Cells(1, 1), Cells(m, n)).Address
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
End Sub