Sub 打印()
Dim i, j
Dim myRow, myCol
Dim mySheet As Worksheet
Dim mySheet2 As Worksheet
Set mySheet2 = ActiveSheet
Set mySheet = Sheets("目录1")
myRow = 60 '每页行数
myCol = 2 '每页表格数
myCol2 = 4 '表格间间隔列数
mySheet2.Range("A1:G65536").Clear '清除原表内容
mycnt = mySheet.Range("A65536").End(xlUp).Row '目录1行数
For j = 0 To myCol - 1
'表格标题行
mySheet.Select
Range("A1:C1").Copy
mySheet2.Select
Range("A1").Offset(0, j * myCol2).PasteSpecial
For i = 0 To Int(mycnt / myRow / myCol)
'表格数据
mySheet.Select
Range("A2:C61").Offset((i * myCol + j) * myRow, 0).Copy
mySheet2.Select
Range("A2").Offset(i * myRow, j * myCol2).PasteSpecial
Next i
Next j
End Sub
是不是这样?