- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
¦^´_ 2# lpk187
·PÁ«ü¾É~
¥t¤@Ó¤èªk¨Ï¥Î¤§«eªO¤W¤j¤j´£¨Ñªº«ü¥Oµy°µ×§ï
쪩 ¬O¦bBÄæ¤w¦³È°µ¤W³sµ²- .Hyperlinks.Add Anchor:=.Cells(lTargetRow, "B"), _
- Address:=ThisWorkbook.FullName, _
- SubAddress:=ThisWorkbook.Sheets("«È¤á©ú²Ó").Name & "!" & Rows(lSourceRow).Address, _
- TextToDisplay:=.Cells(lTargetRow, "b").Text
½Æ»s¥N½X קï«á ¥u¦AAOÄæªÅ¥ÕÀx¦s®æ¶K¤W¸ô®|~¤£¶K¤Wì©l¸ê®Æªº½d³òÀx¦s®æ- .Hyperlinks.Add Anchor:=.Cells(lTargetRow, "AO"), _
- Address:=ThisWorkbook.FullName, _
- SubAddress:=ThisWorkbook.Sheets("«È¤á©ú²Ó").Name & "!" & Rows(lSourceRow).Address, _
- TextToDisplay:=.Cells(lTargetRow, "ao").Text
½Æ»s¥N½X |
|