|
各位老师好,请问Subscript Out of Range如何解决?
题目:
为当前选中的区域单元格中公司增加四张相应的报表(rep1, rep2, rep3, rep4)。每张报表为一单独工作表,工作表名称格式为 两位数连续编号_公司名_报表名 , 如 "01_c1_rep1", "01_c1_rep2",..., "05_c2_rep1".
代码如下(报错处标红),文件见附件。谢谢!
- Option Explicit
- Dim sheet As Worksheet
- Dim i, j, k, l As Integer
- Sub main()
- createsheets
-
- End Sub
- Function createsheets()
-
- For i = 1 To number
- For j = 1 To 4
- Set sheet = Application.Workbooks("Draft.xlsx").Worksheets.Add(after:=Worksheets("source"))
- sheet.Name = Format(i, "0#") & "_" & selectname(i) & "_" & sheetname(j)
- Next j
- Next i
-
- End Function
- Function selectname(l)
-
- Dim arr2()
- arr2(l) = Selection(l) <font color="Red">'此处报错</font>
-
- End Function
- Function sheetname(k)
- Dim arr()
- arr = Array("rep1", "rep2", "rep3", "rep4")
- sheetname = arr(k)
- End Function
- Function number()
- number = Selection.Rows.Count
-
- End Function
复制代码
|
|