|
本帖最后由 西瓜9527 于 2019-6-14 14:17 编辑
附件上传不了,我说说修改步骤吧:
1、把表1 A4-L4单元格的字体格式改成红色、黑体(以后录入的时候不需要此步骤)
2、ALT+F11修改模块代码
3、如果不行我晚上再上传or加我Q
Application.ScreenUpdating = False
With Sheets("Sheet2").Range("A4:L1000")
.Font.Name = "微软雅黑" '????????
.Font.ColorIndex = 1 '???????
.Font.Bold = False '????
End With
For i = 1 To 12
Sheets("Sheet1").Cells(4, i).Copy
Sheets("Sheet2").Cells(1048576, i).End(3).Offset(1, 0).PasteSpecial Paste:=xlPasteAllExceptBorders, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Next
Sheet1.Range("a4:l4").ClearContents
Application.ScreenUpdating = True
|
|