|
可用VBA代码按源表的行高列宽重设账单存根的行高列宽。详见附件。
设置行高列宽的宏名为tableformat
代码如下
Sub tableformat()
Dim i As Integer
Dim columnabc As Variant
columnabc = Array("A", "B", "C", "D", "E")
Application.ScreenUpdating = False
For i = 1 To 33
Sheets("帐单存根").Rows(CStr(i) & ":" & CStr(i)).RowHeight = Sheets("报帐单").Rows(CStr(i) & ":" & CStr(i)).RowHeight
Next
For i = 0 To UBound(columnabc)
Sheets("帐单存根").Columns(columnabc(i) & ":" & columnabc(i)).ColumnWidth = Sheets("报帐单").Columns(columnabc(i) & ":" & columnabc(i)).ColumnWidth
Next
Application.ScreenUpdating = True
End Sub
|
|