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

³sÄòÂà§é½u­n«ç»òµe!!

³sÄòÂà§é½u­n«ç»òµe!!

¥Ø«e¦bexcel¤W¦³»Ý­n¥Î¨ìµe½uªº°Ê§@
¦ý©¹©¹­n¥Îªº½u±ø¬O¦h­ÓÂà§éªº½u±ø
¥i¯à¤ô¥­¡AµM«á©¹¤U¨«¡A¤SÂà¤ô¥­¡A±µµÛ¤W¨«
¦pªG¥Î­ì¥»ªºµe¹Ï¡A»Ý­n¨C¬q¨C¬q¦Û¤v±µ°_¨Ó
¦³¿ìªk¼gµ{¦¡
Åýµe½u±ø®É
ªì©lÂI¥Î·Æ¹«©w¸q«á
¶}©lµe½u(¤]³\·|¥Î¨ìShift«O«ù¤ô¥­««ª½)
¹J¨ìÂà§é®É¡A¥Î·Æ¹«½T©w«á¡A¶}©l¥t¤@­Ó¤è¦VªºÃ¸»s
³Ì«áµ²§ôªº®É­Ô¡A¥i¥H¥ÎESC©Î¬O·Æ¹«³sÄòÂI¨â¤U¤§Ãþªº
²×¤îø¹Ï!!
¦³¿ìªk¹F¨ì³o¥\¯à¶Ü???

¦^´_ 1# yenwang
¦]¬°¤£ª¾¹D§A¨ì©³­nµe¦¨¬Æ»ò¼Ë¤lªº¹Ï§Î,
©Ò¥H«Øij§A¥i¥H¸Õ¸Õ¥Î¨t²Î¥»¨­´N¦³ªº "¿ý»s·s¥¨¶°" ¥\¯à,
¥ý¥Î¤H¤uø»sªº¤è¦¡Åý¨t²Î¦Û°Ê²£¥Íµe¹Ï§Îªºµ{¦¡,
¦A¹Á¸Õ­×§ï¦¨§A­nªºµ²ªG.

¦p¤U¦¡´N¬O¿ý»s¥X¨Óªº:
  1. Sub Macro1()
  2.     ActiveSheet.Shapes.AddLine(64.5, 58.5, 237#, 58.5).Select
  3.     ActiveSheet.Shapes.AddLine(192.75, 59.25, 237.75, 285.75).Select
  4.     Selection.ShapeRange.Flip msoFlipHorizontal
  5. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD