"Sheets(x).a1",语句出的问题 ,你能帮我改一下这个吗?
Sub Macro11()
Sheets.Add after:=Sheets(Sheets.Count)
a = Sheets.Count
Sheets(a).Select
Sheets(a).Name = "目录1"
For x = 1 To a - 1
Cells(x, 1).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheets(x).a1", TextToDisplay:=Sheets(x).Name
Next
End Sub
Sub Macro11()Sheets.Add after:=Sheets(Sheets.Count)a = Sheets.CountSheets(a).SelectSheets(a).Name = "目录1"For x = 1 To a - 1Cells(x, 1).SelectActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet" & x & "!A1", TextToDisplay:=Sheets(x).NameNextEnd Sub