Sub Test() Dim s1 As String
Sheet1.Select
Dim i As Integer i = 1
s1 = "sheet" + i
Cells(1, 1) = s1 '或用sheets(s1).name
Next i
End Sub就是无法获取表的名字啊。
Sheet1.Select
Dim i As Integer i = 1
s1 = "sheet" + i
Cells(1, 1) = s1 '或用sheets(s1).name
Next i
End Sub就是无法获取表的名字啊。
("sheet"+i).操作 来代替,该如何来写。其实似乎就是将("sheet"+i)转化为sheets对象,这样便可以使用一些函数。
Debug.Print wk.Name
NextEnd Sub
--------------------
把这句改为:
s1 = "sheet" & i
Dim s1 As String
Sheet1.Select
Dim i As Integer
For i = 1 To ActiveWorkbook.Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next
End Sub