|
把这句TextToDisplay:=Worksheets(i).Name改成TextToDisplay:=Worksheets(i).range("a1")&""
比如:
Sub Macro1()
Dim i, n
With Worksheets(1)
.Range("C1:C1000").Hyperlinks.Delete
.Range("C1:C1000").Clear
For i = 2 To Worksheets.Count
.Cells(i, 3).Hyperlinks.Add Anchor:=.Cells(i, 3), Address:="", SubAddress:="'" & Worksheets(i).Name & "'!A1", TextToDisplay:=Worksheets(i).Range("a1") & ""
Next i
End With
End Sub |
评分
-
查看全部评分
|