- ©«¤l
- 30
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 34
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2013-11-30
- ³Ì«áµn¿ý
- 2023-1-12
|
¦^´_ 1# li_hsien
À³¸Ó¬O¥i¥Hªº¡A¥u¬O¬°¤°»ò§Ú¤@ª½¥¢±Ñ...:'(
¦³«e½ú¥i¥HÀ°¦£¤@¤U¶Ü ....
example.rar (17.94 KB)
Dim i As Long
With Worksheets("¤u§@ªí1")
For i = 1 To 4
On Error Resume Next
.Cells(i, 1).Hyperlinks.Delete
On Error GoTo 0
.Hyperlinks.Add Anchor:=.Cells(i, 1), Address:="EXAMPLE" & "\" & Left(Cells(i).Text, 11), TextToDisplay:=Left(.Cells(i, 1).Text, 1)
¬°¤°»ò«á±>>>Left(Cells(i).Text, 11)<<<³£¨S¦³Åã¥Ü... |
|