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

[µo°Ý] ¯à§_·j´M¤u§@ªíªº¦WºÙ

­n¬Ý©w¸q¦WºÙ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# et5323


­è­è±N±zªº¤½¦¡®M¥Î¦b§Ú¦Û¤vªºÀɮ׸̡Aµ²ªGµo²{¤@­Ó«Ü¤jªº°ÝÃD¡A¨º´N¬O¤u§@ªí¦WºÙ¬°¤¤¤åªº¡A¥þ³¡³£·|§e²{¡­NAME¡H­C¡A³o¤U¤l¥i«ç»ò¿ì¤~¦n§r¡H

TOP

¦^´_ 6# oobird


    ­ì¨Ó«ö¥kÁä´N¥i¥H¥X²{³o­Ó¥\¯à¤FQQ¡A¨S¬Ý¨ì±zªº¹ÏÁÙ¯u¨S·Q¨ì­n¥h¸Õ¹L~~~©Ò¥H¨Sµo²{³o»ò²³æ

TOP

¦^´_ 7# PD961A
¦Û­q¨ç¼Æ
Function ¤u§@ªíÁ`¼Æ() As Integer
    Application.MacroOptions "¤u§@ªíÁ`¼Æ", Description:="­pºâ¤u§@ªíÁ`¼Æ", Category:=11
    Application.Volatile
    ¤u§@ªíÁ`¼Æ = ActiveWorkbook.Sheets.Count
End Function

TOP

=INFO ("numfile") ¥i±o¨ì¤w¶}±Òªº¬¡­¶Ã¯¤¤¤u§@ªíÁ`¼Æ¡C
¦ý¥ý¨M±ø¥ó¬O¥u¶}¤@­Ó¬¡­¶Ã¯¦Ó¥B¨S¦³¥[¸ü¨ä¥L¼W¯q¶°¡C
¨ä¹ê¥Î½sµ{msgbox sheets.count³Ì§Ö

TOP

¦^´_ 6# oobird


    ª©¥D±z¯uÁo©ú...
    ¦ý¬O¨º­Ó°Ê§@¤£¯àª¾¹D¤u§@ªí"¼Æ¶q"ªü??
    ­n«ç»ò­pºâ?
    ÁÂÁ±z...
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

§ä¤u§@ªí·|Ãø¶Ü¡H
a.gif

TOP

¦^´_ 3# et5323

¥ý¶i
©Monegirl0204¤@¼Ëªº·Qªk
µo²{®Ú¥»´N¤£¥²¨¯­W¦a¦b¥Ø¿ýÄæ¸Ì¥´¤W¦UªÙ¸ê®Æ§¨ªº¦WºÙ¦A¤À§O¥[¤J¶W³sµ²¥\¯à
¥i¥H½Ð±z«ü¾É¶Ü?
·PÁ±z¡I...
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 3# et5323


­è­è¤U¸ü¤F±z´£¨Ñªº¸ê®Æ¡Aµo²{®Ú¥»´N¤£¥²¨¯­W¦a¦b¥Ø¿ýÄæ¸Ì¥´¤W¦UªÙ¸ê®Æ§¨ªº¦WºÙ¦A¤À§O¥[¤J¶W³sµ²¥\¯à¡A¥i§_½Ð±Ð±z´£¨Ñªº¨ç¼Æ¬ÛÃö±Ð¾Çºô§}§@¬°¾Ç²ß¤§¥Î©O¡H·PÁ±z¡I

TOP

¥»©«³Ì«á¥Ñ et5323 ©ó 2010-10-6 20:56 ½s¿è

¥Î§»ªí¨ç¼Æ©w¸q¤F¦WºÙ¡Gsht
Book1.rar (1.63 KB)

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD