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

[µo°Ý] CommandButton³]©w

[µo°Ý] CommandButton³]©w

½Ð°Ý«e½ú­Ì~
¤p§Ì±ý³]©w¤@­Ó¦æ¥i¼W¥[´î¤Ö«ö¶s..ª½±µ¥Î¿ý»s«á­±§â   Rows("2:2").Select §ï¦¨Rows().Select¿ù»~
½Ð°Ý¸Ó¦p¦ó³]©w©O~
  1. Sub ¼W¥[()
  2. '
  3. ' ¼W¥[ ¥¨¶°
  4. '
  5. Rows("2:2").Select
  6.     Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
  7. End Sub

  8. Sub §R°£()
  9. '
  10. ' §R°£ ¥¨¶°
  11. '
  12.   Rows("2:2").Select
  13.     Selection.Delete Shift:=xlUp
  14. End Sub
½Æ»s¥N½X

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