使用 Excel 365。 我正在尝试根据 ThisWorkbook 工作表中 Data 的 K4 单元格中的队伍数量,从 "Tournament Master Format 36.xls" 模板中复制一个工作表(所有选项卡都基于括号中有多少个团队)。
Sub CopyPaste()
Dim Size As String
Size = "ThisWorkbook.Sheets("Data").Range("K4")"
Workbooks("Tournament Master Format 36.xls").Sheets(Size).Range("A1:AO311").Copy _
ThisWorkbook.Sheets("Sheet4").Range("A1")
End Sub
更新后的代码:
Sub CopyPaste()
Dim Size As String
Dim i As Integer
Dim SheetNum As String
Dim ws As Worksheet
Workbooks("Scheduling Test Template.xlsx").Sheets("Data").Activate
For i = 2 To 10
'Size = Cells(i, 11).Value
Size = CStr(Workbooks("Scheduling Test
Template.xlsx").Sheets("Data").Range("K4").Value)
'SheetNum = CStr(Cells(i, 10)) + " & Under"
SheetNum = i
Debug.Print Size
If Size > 0 Then
Set ws =
ThisWorkbook.Sheets.Add(After:=ThisWorkbook.Sheets
(ThisWorkbook.Sheets.Count))
ws.Name = SheetNum
Workbooks("Tournament Master Format 36.xls").Sheets(Size)
.Range("A1:AO311").Copy ThisWorkbook.Sheets(SheetNum).Range ("A1")
End If
Next i
End Sub
ThisWorkbook.Sheets("Data").Range("K4")
放在引号中 - 这样它就变成了一个字面字符串,而不是你想要的对象的值。坦白地说,我很惊讶它甚至能这样编译。 - braX