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

«ö¶s·j´M¦pªG³]¸m©O¡H

«ö¶s·j´M¦pªG³]¸m©O¡H

·Q½Ð°Ý¦U¦ì¤j¤j
­Y¬O·Q¦bExcel¤¤³]¤@­Ó«ö¶s¡A¥´¤W­n·j´Mªº¦r¦ê¡Aµe­±´N¥i¥H¸õ¨ì¨º­ÓÀx¦s®æ¡A­n«ç»ò¥Î©O¡H
(¹³¬OCtrl+F¨º¼Ëªº®ÄªG)

¦A³Â·Ð¤j¤j­ÌÀ°¦£¸Ñµª¡CÁÂÁ¡I

¦^´_ 1# ÄÉ¡C

¦pªþ¥ó¡A¦bA1:G20¶¡¿é¤J¦r¦ê¡A°õ¦æ¥¨¶°¡A¿é¤J·j´M¦r¦ê¡A´N¥i¦Û°Ê¸õ¨ì¸ÓÀx¦s®æ~
test.rar (12.13 KB)

TOP

¦^´_ 2# tku0216

Application.Goto Range(finddom.Address)
·|¶]¨ìActiveSheet¦ì¸m

«Øij¥i¥H§ï¬°

Application.Goto finddom
·í finddom ­Y¤£¬O¦b ActiveSheet ®É¡A³o¼Ë¤~·|¶]¥¿½T¶]¨ì finddom ªºSheet¡BWorkBook¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  ÄÉ¡C

¦pªþ¥ó¡A¦bA1:G20¶¡¿é¤J¦r¦ê¡A°õ¦æ¥¨¶°¡A¿é¤J·j´M¦r¦ê¡A´N¥i¦Û°Ê¸õ¨ì¸ÓÀx¦s®æ~
tku0216 µoªí©ó 2016-3-5 21:39


¤j¤jÁÂÁ±zªºÀ°§U
¥i¬O¡K«Ü¤£¦n·N«äªº¬O¡A¦]¬°§Ú¥Ø«eÁÙ¬O¤p¾Ç¥Í¡AµLªk¤U¸üªþ¥ó¡K
¬O§_¥i¥H¦³¥t¥~ªº³sµ²©O¡HÁÂÁ±z¡C

TOP

¦^´_ 3# ML089

¤j¤j§Ú¤£¤j¤F¸Ñ±zªº·N«ä¡A¦]¬°§Ú¤w¸g³]©wdom¬°¤u§@ªí2ªº¯S©w½d³ò¡A¬G·j´Mµ²ªG¡A§Ú¹Á¸Õ¹LµL½×¬O¦b¤u§@ªí¤G©Î¬O·s¼W¤@­Ó¤u§@ªí¡A·j´M«á¬Ò·|¸õ¨ì¤u§@ªí¤G¸Ì­±¡A¸m´«±zªºµ{¦¡½X¤]¤£·|¹ï·j´Mµ²ªG³y¦¨¼vÅT¡A½Ð°Ý§Ú¬O§_¦³»~¸Ñ±zªº·N«ä¡H

TOP

¦^´_ 4# ÄÉ¡C

½Ð¹Á¸Õ¥H¤U³sµ²¡G
https://drive.google.com/file/d/0B7UZjepz0qBUenFQMm1LdFpsd0U/view?usp=sharing

TOP

¦^´_ 5# tku0216

§Ú´ú¸Õ§Aªºµ{¦¡³£OK¡A¦b¨ä¥L¤u§@ªí°õ¦æ³£·|¸õ¦^¸Ó¤u§@ªí¡C


¦ý¤U¦¡¦³¨Ç´ú¸Õ·|¦³¤£¦Pµ²ªG´£¨Ñ§A°Ñ¦Ò
Application.Goto Range(finddom.Address)

­Yµ{¦¡©ñ¦b¤u§@ªí®É¡A¤£ºÞ¦b­þ¸Ì­Ó¤u§@ªí°õ¦æ·|¸õ¦^¸Ó¤u§@ªíªº Range(finddom.Address)
­Yµ{¦¡©ñ¦b¼Ò²Õ®É¡A¥u·|¸õ¨ì¸ÓActive¤u§@ªíªº Range(finddom.Address)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  ÄÉ¡C

½Ð¹Á¸Õ¥H¤U³sµ²¡G
https://drive.google.com/file/d/0B7UZjepz0qBUenFQMm1LdFpsd0U/view?u ...
tku0216 µoªí©ó 2016-3-6 23:28


¥i¥H¤F¡A·PÁ±z®@:-)

TOP

¦^´_ 7# ML089


ÁA¸Ñ¤F¡AÁÂÁ¤j¤j¤À¨É~

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD