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

¦b¤u§@ªí°õ¦æ¥t¤@®æ¤u§@ªíªº¥¨¶°

¦b¤u§@ªí°õ¦æ¥t¤@®æ¤u§@ªíªº¥¨¶°

½Ð±Ð¦U¦ì¤j¤j:
³o¬O°õ¦æ¨ä¥L¬¡­¶Ã¯ªº¥¨¶°µ{¦¡
Sub Sample()
    Application.Run "Àɮצì¸m!Module1.Macro1"
End Sub
¦pªG§Ú·Q§ï¦¨¦b¦P¤@­Ó¤u§@ï¤W²Ä¤@­Ó¤u§@ªí¤W°õ¦æªº¤G­Ó¤u§@ªí¤Wªº¥¨¶°
½Ð°Ý­n¦p¦ó¼g³o­Óµ{¦¡
ÁÂÁÂ
michael

¥»©«³Ì«á¥Ñ luhpro ©ó 2016-4-25 23:42 ½s¿è
½Ð±Ð¦U¦ì¤j¤j:
³o¬O°õ¦æ¨ä¥L¬¡­¶Ã¯ªº¥¨¶°µ{¦¡
Sub Sample()
    Application.Run "Àɮצì¸m!Module1.Mac ...
chairles59 µoªí©ó 2016-4-25 00:54


Call Sheets("Sheet2").cc

©Î

Sheets("Sheet2").cc

TOP

¦^´_ 2# luhpro

ÁÂÁ¤j¤j
¦]¬°¤H¦b®È¹C¡A
¤â¤¤¨S¦³¹q¸£¥i¥H´ú¸Õ
©ú¤Ñ¦^¥h¦A´ú¸Õ
michael

TOP

¦^´_ 2# luhpro


    ¤j¤j:
´ú¸Õ¦n¹³¤£¦æ
¥L¥X²{
°õ¦æ¶¥¬q¿ù»~9
°}¦C¯Á¤Þ¶W¥X½d³ò

Call Sheets("Sheet2").cc
.cc¬O¬Æ»ò·N«ä
½Ð¤j¤jÀ°§Ú±Ð¾É¤@¤U
michael

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2016-4-29 00:08 ½s¿è
¦^´_  luhpro


    ¤j¤j:
´ú¸Õ¦n¹³¤£¦æ
¥L¥X²{
°õ¦æ¶¥¬q¿ù»~9
°}¦C¯Á¤Þ¶W¥X½d³ò

Call Sheets("Sheet2").cc

chairles59 µoªí©ó 2016-4-28 22:08

§A#1 ªº±Ô­z¬O :

¦pªG§Ú·Q§ï¦¨¦b¦P¤@­Ó¤u§@ï¤W²Ä¤@­Ó¤u§@ªí¤W°õ¦æªº¤G­Ó¤u§@ªí¤Wªº¥¨¶°

¬Ý¤£¥X¨Ó  ¥¨¶°©Ò¦b¤u§@ªíªº¦WºÙ,
¤Î·Q°õ¦æªº¥¨¶°¦WºÙ,
©Ò¥H§Ú¥u¯à¦Û¤v­q,
§A­n§ï¦¨§AÀɮפ¤ªº¦WºÙ,
¦Ó¤£¬Oª½±µ·Ó·h.

·|¥X²{ °}¦C¯Á¤Þ¶W¥X½d³ò ªº¿ù»~¬O¥¿±`ªº,
¦]¬°§AªºÀɮ׸̨S¦³¦WºÙ¬° Sheet2 ªº¤u§@ªí.

Call Sheets("Sheet2").cc
¤W¦¡¤¤:
1. Sheet2 ¬O¤u§@ªí¦WºÙ, ½Ð±a¤J§A·Q­n°õ¦æªº¥¨¶°©Ò¦bªº¤u§@ªí¦WºÙ.
2. cc ¬O¥¨¶°¦WºÙ, ½Ð±a¤J§A·Q­n°õ¦æªº¥¨¶°ªº¦WºÙ.

TOP

¥»©«³Ì«á¥Ñ chairles59 ©ó 2016-4-29 21:21 ½s¿è

[attach]24108[/attach][attach]24108[/attach]¦^´_ 5# luhpro

luhpro ¤j¤j:
¦n¹³¤]¤£¦æ
§Ú§âÀ£ÁYÀɮתþ¤W
½Ð¤j¤jÀ°§Ú¬Ý¤@¤U«ö¶s7ªº¥¨¶°¨º¸Ì¦³°ÝÃD

ÁÂÁÂ

ps:·Ç¤j¤j¤£¦n·N«ä
±zªºµ{¦¡§Ú¥[¤F¦n¦h­Ó«ö¶s

ªÑ²¼.rar (49.56 KB)

michael

TOP

¦^´_ 5# luhpro

luhpro ¤j¤j:
¤£¦n·N«ä§Ú¦b¶}µo¤H­û°õ¦æ°»¿ù,«öF8®É¥L§i¶D§Ú
°õ¦æ¶¥¬q¿ù»~438
ª«¥ó¤£¤ä´©¦¹ÄݩʩΤèªk

    ¦ý¬O§Ú¦bSheet1(§Y®É¸ê°T)·s¼WªÑ²¼«ö¶s«o¯à°õ¦æ
michael

TOP

¦^´_ 7# chairles59
§Aªº Sheets("®æ¦¡") ¸Ì¨Ã¨S¦³ ·s¼WªÑ²¼¦WºÙ ³o­Ó Sub,
©I¥s·íµM·|¥¢±ÑÅo...

§A¥u­n§â  Sheets("®æ¦¡").  ®³±¼,
§ï¬°ª½±µ©I¥s "·s¼WªÑ²¼¦WºÙ" §Y¥i:
  1. Sub ½Æ»s®æ¦¡¤u§@ªí()
  2.   ·s¼WªÑ²¼¦WºÙ
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 8# luhpro


    ÁÂÁ¤j¤jªº±Ð¾É
:)
michael

TOP

¦^´_ 9# chairles59
³o¥i¤À¦¨¨â³¡¤À¨Ó»¡©ú¡AµL½×¬O¦óºØ¤è¦¡µª®×¬O¤@­Pªº¡A
®t§O¥u¦b©óªí¹Fªº¤è¦¡¦]¤H¦Ó²§¡G
A. ±N¡y·s¼WªÑ²¼¦WºÙ¡zµ{¦¡ (·s¼WªÑ²¼¦WºÙ())
   ©ñ¸m©ó ¡u¤u§@ªí1 (®æ¦¡)¡v ¤º

©I¥s¤è¦¡¤@¡G
  1. Sub ½Æ»s®æ¦¡¤u§@ªí()
  2.     Sheets("®æ¦¡").·s¼WªÑ²¼¦WºÙ
  3. End Sub
½Æ»s¥N½X
©I¥s¤è¦¡¤G¡G
  1. Sub ½Æ»s®æ¦¡¤u§@ªí()
  2.     Call Sheets("®æ¦¡").·s¼WªÑ²¼¦WºÙ
  3. End Sub
½Æ»s¥N½X
©I¥s¤è¦¡¤T¡G
  1. Sub ½Æ»s®æ¦¡¤u§@ªí()
  2.     ¤u§@ªí1.·s¼WªÑ²¼¦WºÙ
  3. End Sub
½Æ»s¥N½X
©I¥s¤è¦¡¥|¡G
  1. Sub ½Æ»s®æ¦¡¤u§@ªí()
  2.     Call ¤u§@ªí1.·s¼WªÑ²¼¦WºÙ
  3. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD