如下是“生成工资条格式”、“打印预览”、“清空内容”的三个功能实现：
Sub CtoPrt() '生成工资条格式 Dim mycount As Integer Dim prows As Integer Dim srows As Integer mycount = 0 prows = Sheets("打印").Cells(Rows.Count, 1).End(xlUp).Row srows = Sheets("源数据").Cells(Rows.Count, 1).End(xlUp).Row '清空打印表数据 If prows > 1 Then Application.EnableEvents = False Range(Rows(2), Rows(prows)).ClearContents Application.EnableEvents = True End If '清空打印表格式 Sheets("打印").Cells.Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone Selection.Borders(xlEdgeBottom).LineStyle = xlNone Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone With Selection.Interior .ColorIndex = 0 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Application.ScreenUpdating = False '第一人的工资条直接复制 Sheets("源数据").Select Rows("1:2").Select Selection.Copy Sheets("打印").Select Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False mycount = 1 '从第二人开始 For i = 3 To srows prows = Sheets("打印").Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets("打印").Select Rows(2).Select Selection.Copy Rows(prows).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("源数据").Select Rows(i).Select Selection.Copy Sheets("打印").Select Rows(prows + 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False mycount = mycount + 1 Next i Application.ScreenUpdating = False Dim rnum As Integer Dim cnum As Integer rnum = Sheets("打印").Cells(Rows.Count, 1).End(xlUp).Row cnum = Sheets("打印").Cells(2, Columns.Count).End(xlToLeft).Column If rnum > 2 And cnum > 1 Then Application.EnableEvents = False Range(Cells(2, 1), Cells(rnum, cnum)).Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With Application.EnableEvents = True End If MsgBox "源数据共计" & srows - 1 & "人工资记录，已成功处理" & mycount & "人的工资条格式。", vbOKOnly + 64, "提示" End Sub Sub prtpre() '打印预览 Dim rnum As Integer Dim cnum As Integer rnum = Sheets("打印").Cells(Rows.Count, 1).End(xlUp).Row cnum = Sheets("打印").Cells(2, Columns.Count).End(xlToLeft).Column If rnum > 2 And cnum > 1 Then Application.EnableEvents = False Sheets("打印").Range(Cells(2, 1), Cells(rnum, cnum)).PrintPreview Application.EnableEvents = True Else MsgBox "该表格没有可用记录，不能预览。", vbOKOnly + 64, "提示" End If End Sub Sub clcontents() '清空内容 Sheets("打印").Cells.ClearContents Sheets("打印").Cells.Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone Selection.Borders(xlEdgeBottom).LineStyle = xlNone Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone With Selection.Interior .ColorIndex = 0 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With End Sub