将工作簿中的工作表制成目录汇总在表“目录”A1开始的单元格中
- Sub mulu()
- Dim mysheet As Worksheet
- Dim i As Integer
- For i = 20 To 30
- For Each mysheet In Worksheets
- i = i + 1
- j = j + 1
- Cells(19 + j, 5) = j
- Sheets("目录").Hyperlinks.Add Anchor:=Cells(i - 1, 6), Address:="", SubAddress:=mysheet.Name & "!" & "A1", TextToDisplay:=mysheet.Name
- Next
- Next
- End Sub
本文转自 kirin 51CTO博客,原文链接:http://blog.51cto.com/kirin/713243 ,如需转载请自行联系原作者