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

¤À³Î or ­áµ²

¤À³Î or ­áµ²

½Ð°Ý......
¦P¤@¤u§@ªí¤À¥ª¥k¨âÃä,·Q¥ªÃ䪺¸ê®Æ¥i¥H¤W¤U±²°Ê, ¥kÃ䪺¸ê®Æ«h©T©w¤£°Ê, ¸Ó«ç»ò¥Î?ÁÙ¬O¨S³o­Ó¥\¯à?
ªì¾ÇªÌcolor

¤£À´·N«ä...
±zªº·N«ä¬O»¡  ­n±N¬YÄæ¦ì©T©w¤£°Ê¡AµM«á ¬d¬Ý¨ä¥L¸ê®Æ®É­Ô¥i¥H¤W¤U±²°Ê???

TOP

À˵ø/¶}·sµøµ¡/¨Ã±ÆÅã¥Ü/««ª½¨Ã±Æ/¨ú®ø¦P¨B±²°Ê
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

À˵ø/¶}·sµøµ¡/¨Ã±ÆÅã¥Ü/««ª½¨Ã±Æ/¨ú®ø¦P¨B±²°Ê
Hsieh µoªí©ó 2011-6-20 17:55



    ª©¤j ¥L¬O»¡¦P¤u§@ªí~~
ª©¤jªº§@ªk¬O¨â­Ó¤u§@ªí§a...
¦L¶H¤¤ 2¤d¬O¦³­Ó¥i¥H±N©T©wÄæ¦ì©T©wµM«á ¤â°Ê¤W¤U²¾°Êªº¥\¯à ¦ý¬O¦~¥N¤Ó¤[»· §Ñ°O«ç³]©w¤F= =

TOP

¨â­Ó¤u§@ªí?
¬O¦P¤@­ÓÀɮסA¥H¨â­Óµøµ¡Åã¥Ü
¦pªG­n¥ª¥k¨âÃä¤À¶}±±¨î±²°Ê¡A¦P¤@µøµ¡¬OµLªk¹F¦¨ªº
³o¥u¬OÀ˵øªº¤èªk¡A§A§ïÅܨ䤤¤@­Óµøµ¡ªº¸ê®Æ¨âÃä´N·|¦P®É§ó§ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-6-21 10:11 ½s¿è

¦^´_ 1# color790


   

¦³¸ÕµÛ°µ¤F¤@­Ó ²Ä¤@¦æ ²Ä¤@¦C ©T©w°_¨Óªº ~~ ¸ÕÅç¬Ý¬Ý§a


off2007 ¥i¥H¥Î¤À³Îªº¥\¯à~~




­áµ².rar (8.27 KB)
  1. Sub Macro2()
  2. '
  3. ' Macro2 Macro
  4. '
  5. ' §Ö³tÁä: Ctrl+f
  6. '
  7.     Columns("A:A").Select   ' ³oÃ䪺¸Ü ¥i¥H³]©w¦h­ÓÄæ¦ì ¦p A:B ©Î B:C µ¥µ¥¤§Ãþªº
  8.     ActiveWindow.SmallScroll Down:=-21
  9.     With ActiveWindow
  10.         .SplitColumn = 1
  11.         .SplitRow = 0
  12.     End With
  13.     ActiveWindow.FreezePanes = True
  14.    
  15.     Rows("2:2").Select   
  16.     ActiveWindow.SmallScroll Down:=-21
  17.     With ActiveWindow
  18.         .SplitColumn = 1
  19.         .SplitRow = 1
  20.     End With
  21.     ActiveWindow.FreezePanes = True

  22. End Sub
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ color790 ©ó 2011-6-21 16:41 ½s¿è
¦^´_  color790


   

¦³¸ÕµÛ°µ¤F¤@­Ó ²Ä¤@¦æ ²Ä¤@¦C ©T©w°_¨Óªº ~~ ¸ÕÅç¬Ý¬Ý§a


off2007 ¥i¥H ...
mark15jill µoªí©ó 2011-6-21 09:58


ÁÂÁ¤j®aªºÀ°¦£ :)
???? ¤£¤ÓÀ´³o¥¨¶°ªºµ²ªG, §Úªº·N«ä¬O¦P¤@¤u§@ªí¤À³Î¦¨¦p AÄæ~GÄæ & HÄæ~X
µM«áAÄæ~GÄ橹¤U±²°Ê,¦Ó¥kÃ䪺HÄæ~X«h©T©w¤£°Ê
¤£¹Lª©¤j³o­Ó¥Îªk¤]¤£¿ù~·P®¦
ªì¾ÇªÌcolor

TOP

§Úªº·N«ä¬O¦P¤@¤u§@ªí¤À³Î¦¨¦p AÄæ~GÄæ & HÄæ~X
µM«áAÄæ~GÄ橹¤U±²°Ê,¦Ó¥kÃ䪺HÄæ~X«h©T©w¤£°Ê

¤£¥i¯àªº¨Æ´N§O²§·Q¤Ñ¶}°Õ¡I

TOP

¦^´_ 7# color790


    ¦pªG¬O¥Î©T©wªº¸Ü ¥u¯à©T©w~ ¤W¤U²¾°Ê~~

TOP

½Ð°Ý¡AHsieh¶W¤jªº½d¨Ò¦n¹³Âª©excelµLªk³o¼Ë°µ¡H(¦P¤@­ÓÀÉ®×¥H¨â­Óµøµ¡Åã¥Ü)
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD