|
楼主 |
发表于 2015-1-25 11:55
|
显示全部楼层
dsmch 发表于 2015-1-25 11:47
非常感谢 dsmch 提供的答案。
能否帮我将下面的代码合并到一起,并且增加个所有的单元格居中自动换行显示呢?
Sub test()
Dim sh
For Each sh In Worksheets
Application.PrintCommunication = False
sh.PageSetup.PrintTitleRows = "$1:$1"
Application.PrintCommunication = True
Next
End Sub
Sub Macro1()
Dim i%, j%, k&
For i = 1 To Sheets.Count
With Sheets(i)
For j = 1 To 18
.Cells(1, j).EntireColumn.ColumnWidth = 6.5
Next
.Cells(1, 19).EntireColumn.ColumnWidth = 9
For k = 1 To .UsedRange.Rows.Count
.Cells(k, 1).EntireRow.RowHeight = 25
Next
End With
Next
End Sub
|
|