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

COUNTA ©Î¬Y¨Ç¨ç¼Æ¦bVBA¤W¨Ï¥ÎªººÃ°Ý

COUNTA ©Î¬Y¨Ç¨ç¼Æ¦bVBA¤W¨Ï¥ÎªººÃ°Ý

Dear ¤j¤j­Ì

      ¤p§Ì¦bVBA¼¶¼g¦³Ãö¨ç¼Æ³¡¥÷ªºµ{¦¡½X®É,³£·|¦³¤@­Ó°ÝÃD
      ´N¬O¦bSHEET1Ū¨úSHEET2ªº¸ê®Æ®É,·|Ū¤£¨ì,¨Ò¦pªþ¥ó¤¤ªºCOUNTA³o­Ó¨ç¼Æ

      ¯à§_½Ð¤j¤jÁ¿¸Ñ¤@¤U,°ÝÃD¬O¤°»ò??? ¨ä¨ç¼Æ¦bVBA¤W¼¶¼gªº°ò¥»Æ[©À¬°¦ó?? ¦nÅý¤p§Ì¥i¥H¾Ç²ß~


         ¦bVBA¤º¨Ï¥ÎCOUNTA¨ç¼Æ´ú¸Õ.rar (8.23 KB)

¦^´_ 1# hugh0620


          Sheet1.Cells(1, 1) = Application.CountA(Sheet2.[A7:A65536])
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# hugh0620
§Aªºµ{¦¡½X¬O¦b Sheet1ª«¥ó
    Sheet1.Cells(1, 1) = Sheet2.Application.CountA([A7:A65536])
[A7:A65536] ¬O¶Ç¦^ Sheet1ªº¤u§@ªíªº¦ì¸m  ->¦p­n«ü©w¥»¨­¤u§@ªí¥H¥~ªº¤u§@ªí»Ý«ü©ú

¦p§Aªºµ{¦¡½X¬O¦b ¤@¯ë¼Ò²Õ(Module )
    Sheet1.Cells(1, 1) = Sheet2.Application.CountA([A7:A65536])
[A7:A65536] ¬O¶Ç¦^ §@¥Î¤¤¤u§@ªíªº¦ì¸m(ActiveSheet)   ->¦p­n«ü©w§@¥Î¤¤¤u§@ªí(ActiveSheet)¥H¥~ªº¤u§@ªí»Ý«ü©ú

TOP

®@
³o¼Ë§Ú¤]¦h¾Ç¤F¤@©Û®@
ÁÂÁ¤À¨ÉÅo
jeason

TOP

¦^´_ 3# GBKEE


    ÁÂÁ¤j¤jªº¸Ô²Ó»¡©ú~ Åý§Ú¯à°÷¤F¸Ñ~ ·P®¦~

TOP

¦^´_ 2# Hsieh


    ÁÂÁ¤j¤j~ ­ì¨Ó§Úªºsheet2¬O©ñ¿ù¤F¦ì¸m

TOP

EXCEL SHEET ¸òActiveSheet «Ü¤£®e©ö²z¸Ñ
»Ý­nÅçÃÒ¡C¨ì²{¦bÁÙ¬OµLªk«Ü®e©ö²z¸Ñ@@

¯u¬O¶Ë¸£µ¬

TOP

¦^´_ 3# GBKEE


    Dear ¤j¤j

        ¤p§Ì·Q­n¦A½Ð°Ý¤@­Ó°ÝÃD
        ­Y¬O§Ú¦b¥ÎCOUNTA¥h²Î­p®É,­Y§Úªº°Ï¶¡¬O¤£¤@©wªº®É­Ô,´N·|¦³°ÝÃD
           ¤@¯ë¥¿±`ªº¼gªk¬O
        Application.CountA(Sheet2.[E22: E65536]) [©T©T°Ï¶¡¶i¦æ²Î­p)
           ­Y§Ú¤wW¬O¤@­ÓRowªº¼Æ­È(¥ç§Y¬O¸ÓÀx¦s®æ¬O¦b²Ä´X¦C)        
        Application.CountA(Sheet2.[E&W: E65536]) [§ïÅܦ¨¥i¯B°Ê°Ï¶¡¶i¦æ²Î­p]

           ½Ð¤j¤j±Ð¾É§Ú

            COUNTA¶i¶¥°ÝÃD_20110106.rar (9.5 KB)
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 8# hugh0620
Sheet1.Cells(4, 2) = Application.CountA(Sheet1.[A22:A65536])                       '¤£±µ¨üÅܼÆ
Sheet1.Cells(4, 2) = Application.CountA(Sheet1.Range("A" & W & ":A65536")) '±µ¨üÅܼÆ

TOP

¦^´_ 9# GBKEE

   ÁÂÁ¤j¤j~ À°§Ú¸Ñ¨M (§Ú¦Û¤v¸Õ¤F¦Ñ¥b¤Ñ³£µLªk¸Ñ¨M):L
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD