ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

vba ©¹¤U¤@¦Cªº«ü¥O

vba ©¹¤U¤@¦Cªº«ü¥O

vba ©¹¤U¤@¦Cªº«ü¥O
Ãþ¦üSelection.End(xlDown).Selectªº«ü¥O, ¦ý¥u­n¥Ñ©Ò¦b¦C©¹¤U¤@¦C´N¦n, ½Ð¦U¦ì¥ý¶i«üÂI,·PÁÂ!

¦^´_ 1# openpc

Selection.Offset(1).Select

TOP

·PÁ«üÂI!
¦A½Ð±Ð, Selection.Offset(1).Selectªº«ü¥O,¦p¦ó©¹¥ª©Î©¹¥k²¾°Ê¤@Äæ.

TOP

¦^´_ 3# openpc
VBA »¡©ú:
expression.Offset(RowOffset, ColumnOffset)
RowOffset      ¿ï¾Ü©Êªº Variant¡C¥Î¦C¼Æªí¥Üªº°Ï°ì¦ì²¾ (¥¿­È¡B­t¼Æ©Î¹s (0))¡C¥¿­Èªí¥Ü¦V¤U¦ì²¾¡A­t­Èªí¥Ü¦V¤W¦ì²¾¡C¹w³]­È¬° 0¡C
ColumnOffset      ¿ï¾Ü©Êªº Variant¡C¥ÎÄæ¼Æªí¥Üªº°Ï°ì¦ì²¾ (¾ã¼Æ¡B­t¼Æ©Î 0 (¹s))¡C¥¿­Èªí¥Ü¥k¦ì²¾¡A­t­Èªí¥Ü¥ª¡C¹w³]­È¬° 0¡C

TOP

¦^´_ 3# openpc

Selection.Offset(1, 0).Select        ¦V¤U1¦C
Selection.Offset(-1, 0).Select      ¦V¤W1¦C
Selection.Offset(0, 1).Select        ¦V¥k1Äæ
Selection.Offset(0, -1).Select      ¦V¥ª1Äæ

»¡©ú¦p¼Ó¤WGBKEEª©¥D

TOP

·PÁ¤G¦ì¥ý¶i«ü±Ð, ¨Ï§ÚÀò¯q¨}¦h, ©¹«áÁÙ¦³§ó¦hªº¾Ç²ß¤§³B, ½Ð¦A«ü±Ð.

TOP

¬Ý¤Fºô¸ô¤Wªº±Ð¾Ç¦üÀ´«DÀ´¡A¬Ý¤F¨â¦ì¤j¤jªºÁ¿¸Ñ«á§¹¥þ©ú¥Õ¤F¡AÁÂÁÂ

TOP

¦^´_ 5# register313


    ¤µ¤Ñ§Ú¥Î¤W¤F, ÁÂÁ¸ÑÄÀ

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD