[µo°Ý]§âÀx¦s®æ¤º³sµ²ªº¤u§@¶¦ì¸m§ï¦¨¶W³sµ²
- ©«¤l
- 1
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-1-19
- ³Ì«áµn¿ý
- 2015-3-2
|
[µo°Ý]§âÀx¦s®æ¤º³sµ²ªº¤u§@¶¦ì¸m§ï¦¨¶W³sµ²
¦U¦ì«e½ú¤j®a¦n¡A
¤p§Ì·Q½Ð±Ð¦p¦ó¥ÎVBAª½±µ§âÀx¦s®æ¤º³sµ²ªºÀx¦s®æ¤Æ¦¨¶W³sµ²
¨Ò¦pÀx¦s®æ B1¤º³sµ²¨ì Sheet 2ªºA6¡A¦]¦¹¦bB1¤º·|¬O =Sheet2 !A6
¤u§@ªí¤º¦³«Ü¦h³oºØ³sµ²¡A·Q¼g¤@ÓMacro¨Óª½±µ°õ¦æ³oÓ´¡¤J¶W³sµ²ªº°Ê§@¡A³o¼Ë´N¤£¥Î¤@Ó¤@ÓªºÂI¥kÁä½s¿è¶W³sµ²
¥H¤U¬O§Ú¥Ø«e©Ò¼¶¼gªº¡A¦ý¬O³£·|±o¨ì"°Ñ·ÓµL®Ä"ªº°T®§
³Â·Ð¦U¦ì«e½ú¤F
Sub Links()
'
' Links Macro
'
' §Ö³tÁä: Ctrl+Shift+L
'
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Range.Formula"
End Sub |
|
|
|
|
|
|