7,763
社区成员
发帖
与我相关
我的任务
分享
Sub 复制管段材料表模板()
Dim i As Integer
Dim k As Integer
Sheets("管道特性表").Rows.Clear
k = Sheets("操作表格").Range("c2").Value
For i = 1 To k Step 41
Sheets("模板").Select
Rows("1:41").Select
Selection.Copy
Sheets("管道特性表").Select
Range(Cells(i, 1), Cells(i + 40, 60)).Select
ActiveSheet.Paste
'清除剪贴板
Application.CutCopyMode = False
Application.CommandBars("Task Pane").Visible = False
Next
Sheets("操作表格").Select
End Sub
Sub 生成管段材料表()
'第1页
Sheets("全表").Select
Rows("8:40").Select
Selection.Copy
Sheets("管道特性表").Select
Rows("8:40").Select
ActiveSheet.Paste
'清除剪贴板
Application.CutCopyMode = False
Application.CommandBars("Task Pane").Visible = False
'清除剪贴板
Application.CutCopyMode = False
Application.CommandBars("Task Pane").Visible = False
'第2页
Dim i As Integer
Dim j As Integer
Dim k As Integer
j = 1
k = Sheets("操作表格").Range("c4").Value
For i = 41 To k Step 33 '23 15
Sheets("全表").Select
Range(Cells(i, 1), Cells(i + 32, 60)).Select '14
Selection.Copy
Sheets("管道特性表").Select
Range(Cells(i + 8 * j, 1), Cells(i + 8 * j + 32, 60)).Select '26 26 14
ActiveSheet.Paste
'清除剪贴板
Application.CutCopyMode = False
Application.CommandBars("Task Pane").Visible = False
'清除剪贴板
Application.CutCopyMode = False
Application.CommandBars("Task Pane").Visible = False
j = j + 1
Next
Sheets("管道特性表").Select
ActiveSheet.PageSetup.PrintArea = "$B:$BD"
Sheets("操作表格").Select
End Sub