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

¸ê®Æ¿ï¨ú°ÝÃD

¸ê®Æ¿ï¨ú°ÝÃD

½Ð°Ý¦U¦ì«e½ú¡A°²¦p§Ú­n¿ï¨úA1~A10¡A¥u¦³¼Æ¦rªº³¡¤À¡A¤£§t¸Ì­±¦³¤¤¤åªºÄæ¦ì¡A­n¦p¦ó¼¶¼gvba©O¡AÁÂÁÂ

¦^´_ 1# funnydisk
¤u§@ªí§@ªk  «ü¥O:½s¿è->¨ì(G)->¯S®í
¥i ¿ý»s·s¥¨¶° ¸Õ¸Õ¬Ý¬Ý

  1. Option Explicit
  2. Sub Ex() 'SpecialCells ¤èªk
  3.    Range("a1:a10").SpecialCells(xlCellTypeConstants, xlNumbers).Select
  4. End Sub
½Æ»s¥N½X

TOP

¦^´_ 2# GBKEE
·PÁÂGBKEE¤j¤j¡A³º¤£¾å±oÁÙ¦³¯S®í¥Ø¼Ð³o­Ó¥\¯à¡AÁÂÁ¤F

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD