主题：EXCEL VBA复制时格式和内容一起复制问题

根据之前贴的内容已经完成了表单复制之后合并，但表格的行高无法复制，请问以下代码如何修改？

Dim Book As New XLS.Book(ProjectPath & "Attachments\出口公路舱单模板皇岗 - 副本1.xlsx")
Dim fl As String = ProjectPath & "reports\出口公路舱单模板皇岗 - 副本.xlsx"
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws1 As MSExcel.WorkSheet = Wb.WorkSheets("预配(出口)舱单多piao模板") '指定要复制的工作表
Dim Ws2 As MSExcel.WorkSheet = Wb.WorkSheets("sheet1")
Dim Ws3 As MSExcel.WorkSheet = Wb.WorkSheets("sheet2")

Ws2.UsedRange.Copy
ws1.Select
ws1.Cells(Ws1.UsedRange.Rows.Count+1,2).Select '纵向拷贝
ws1.paste

Ws3.UsedRange.Copy
ws1.Select
ws1.Cells(Ws1.UsedRange.Rows.Count+1,2).Select '纵向拷贝
ws1.paste

'Wb.Save
app.Visible = True
'App.Quit