|
小弟在编辑自动创建超链接时出现带括号名称就出现引用无效,如下图:
当名称中有()时,就出现引用无效,正常的无()的均可以正常超链接!
源码如下:
Sub 按钮7_Click()
Dim i, j
i = 3
Do While i <= 300 And Sheet4.Cells(i, 1) <> ""
j = Sheet4.Cells(i, 1)
Sheet4.Cells(i, 1).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
j & "!A1", TextToDisplay:=j
i = i + 1
Loop
End Sub
请知道的大神帮忙!
- Sub 按钮7_Click()
- Dim i, j
- i = 3
- Do While i <= 300 And Sheet4.Cells(i, 1) <> ""
- j = Sheet4.Cells(i, 1)
- Sheet4.Cells(i, 1).Select
- ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="'" & j & "'!A1", TextToDisplay:=j
- i = i + 1
- Loop
- End Sub
复制代码
试试吧,我没有测试
|
|