|
Sub test()
Dim A, B, C, i, j, k, s
Application.ScreenUpdating = False
Sheets(1).Activate
A = Range("a1").CurrentRegion
B = Range("aa1:ae3")
ReDim C(1 To UBound(A) * UBound(B), 1 To UBound(A, 2))
For i = 1 To UBound(A)
For j = 1 To UBound(B)
s = s + 1
For k = 1 To UBound(B, 2)
C(s, k) = IIf(j = 2, A(i, k), B(j, k))
Next k
Next j
Next i
Sheets(2).Activate
Cells.Clear
Range("a1").Resize(s, UBound(C, 2)) = C
'设置格式
For i = UBound(B) To UBound(C) Step UBound(B)
Cells(i, 1).Resize(1, UBound(A, 2)).Merge
Cells(i, 1).RowHeight = 40
Next i
Range("a1").CurrentRegion.EntireColumn.AutoFit
Range("C:C").ColumnWidth = 56
Range("a1").CurrentRegion.Borders.LineStyle = 1
Range("a1").Borders.LineStyle = 1
End Sub
12月下发养老账号密码2.rar
(18.86 KB, 下载次数: 5)
|
|