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

[µo°Ý] EXCEL VBA¡D¦p¦ó¦Û°Ê¿é¤J¸ê®Æ(¥Htab¸õ¤U¤@®æ)

  1. Set Rng = Range("A1:C1,F1:H1,A3:C3,F3:H3,B5:B7,D5:D7,E5:E7,A8,C9:D9")
  2.     'Set Rng = Selection
½Æ»s¥N½X
½Ð°ÝGBKEE¤j¤j¡A±z¼g'Set Rng = Selection·N«ä¬O¡A¦bExcel°õ¦æ¤¤¿ï¾ÜÀx¦s®æ¡A¥i¥H³]©wRngµ¥©ó¿ï©wªºÀx¦s®æ¹À¡H¦pªG§â'Set Rng = Selectionªº'¥h±¼¡C
¤H¥Í¥u¦³¤T¤Ñ¡A¥u¦³¬¡¦b¤µ¤Ñ³Ì½ñ¹ê

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD