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

[µo°Ý] ½Ð°Ý¡u³Ì«á¤@¦æ¸ê®Æ ¤U©Ô½Æ»s¡v¨ì·sªº¤@¦æ¡A¦p¦ó¼g¦¨¥¨¶°©ÎVB©O¡H

[µo°Ý] ½Ð°Ý¡u³Ì«á¤@¦æ¸ê®Æ ¤U©Ô½Æ»s¡v¨ì·sªº¤@¦æ¡A¦p¦ó¼g¦¨¥¨¶°©ÎVB©O¡H

½Ð°Ý¦U¦ì¤j¤j¡G
¦]¬°¨C¤é³£­n§ó·s¤@µ§¸ê®Æ¡A©Ò¥H³£¬O¡u¿ï¨ú¡v¡u³Ì«á¤@¦æ¡v¡A¦A©ì¦²¦V¤U©Ô(½Æ»s)¨ì·sªº¤@¦æ¡C
¦p¹Ï¡G½Æ»s5¤ë2¤éªº¡uA7:E7¡v¡AµM«á¦V¤U©Ô¡AÅܦ¨¦h¤@¦æ 5¤ë3¤éªº¡uA8:E8¡v¡C
            ¥B¨C¤é¦V¤U·s¼W¤@¦æ5¤ë4¤é¡uA9:E9¡v¡B5¤ë5¤é¡uA10:E10¡v¡B5¤ë6¤é¡uA11:E11¡v........

½Ð¦U¦ì¤j¤jÀ°¦£¡A³o¼Ëªº°Ê§@¡A­n¦p¦ó¼g¦¨¥¨¶°©O¡HÁÙ¬O»Ý­n¥ÎVB¼g©O¡H
¤U©Ô½Æ»s.png

¦^´_ 2# GBKEE


    ÁÂÁÂGBKEE¤j¤j³á:loveliness: ¡I¡I

TOP

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2019/5/9 07:43): ½ÐªþÀɬݬÝ

¦^´_ 2# GBKEE


½Ð°Ý GBKEE ¤j¤j¡G
¥Ø«e¹J¨ìªº°ÝÃD...
´N¬OExcel¦@¦³¤T­ÓSheet(Sheet1¡BSheet2¡BSheet3)¡A¦ý¤T­ÓSheet²{¦³ªº¦æ¼Æ³£¤£¦P¡A»Ý­n¤U©ÔªºÄæ¦ì¤]¤£¦P¡A
·Q­n°µ¤@­Ó«ö¶s¡A«ö¤@¤U«ö¶s¡A´N¥i¥H¤@¦¸©ì¦²¤U©Ô¤T­ÓSheet³Ì«á¤@¦æªº¸ê®Æ©O?
Àµ½ÐGBKEE¤j¤j«ü¾É¡I¡IÁÂÁ±z¡I¡I

TOP

¦^´_ 2# GBKEE

·PÁÂGBKEE¤j¤j¡Aªþ¤WÀɮסA³Â·ÐGBKEE¤j¤j«ü¾É¡IÁÂÁ±z¡I¡I

¤u§@ªí1¡÷AÄæ~EÄæ¡A±q14¦æ ©ì¦²¤U©Ô¨ì15¦æ¡C
¤u§@ªí2¡÷AÄæ~GÄæ¡A±q27¦æ ©ì¦²¤U©Ô¨ì28¦æ¡C
¤u§@ªí3¡÷AÄæ~IÄæ¡A±q41¦æ ©ì¦²¤U©Ô¨ì42¦æ¡C

©ì¦²¤U©Ô20190409.rar (14.41 KB)

TOP

¥»©«³Ì«á¥Ñ cslu37 ©ó 2019-5-11 00:15 ½s¿è
¦^´_  cslu37
¸Õ¸Õ¬Ý
³o¤u§@ªí Sheet¼Ò²Õ ªºµ{¦¡½X
GBKEE µoªí©ó 2019-5-5 16:15
  1. Option Explicit
  2. Sub Ex()
  3.     Dim Rng As Range
  4.     Set Rng = Range("A2:E2")
  5.     If Rng.End(xlDown).Row <> Rows.Count Then
  6.         '¤u§@ªíªºÁ`¦C¼Æ: Rows.Count 2003=65536,2010=1048576
  7.         Set Rng = Range(Rng, Rng.End(xlDown))
  8.         '"A2:E2" ©¹¤U©µ¦ù¨ì³Ì«á¤S¸ê®Æªº¦ì¸m
  9.     End If
  10.     'Range.AutoFill ¤èªk ¥i°Ñ»¡©ú
  11.     With Rng
  12.         .AutoFill Destination:=.Rows("1:" & .Rows.Count + 1), Type:=xlFillDefault
  13.         '.Rows("1:" & .Rows.Count + 1)  Rngªº¦C¼Æ+1ªº½d³ò
  14.     End With
  15.    
  16. End Sub
½Æ»s¥N½X
GBKEE¤j¤j±z¦n¡G
    §Ú¹Á¸ÕµÛ§ï¦¨©Ô¨ì¤U¤@¦æ«á¡A¦A±N¾ã¦æ§ï¦¨"­È"¡A¦ýª¦¤åª¦¤F¤@¾ã±ß¡A¤]¹Á¸Õ­×§ï...¦ý¤@ª½¥X²{¿ù»~°T®§>"<
    ½Ð¤j¤j«ü¾É¡A­n¦b­þ¥[¤Wvalue¡A¤~¯à¦b¤U©Ô«á  ¦A§ï¦¨"­È"©O¡H
    ·PÁÂGBKEE¤j¤j¡I¡I

TOP

¦^´_ 7# hcm19522


  ÁÂÁ hcm19522 ªº¤À¨É¡I¡I
  ¥u¬O¹J¨ì¤@­Ó°ÝÃD...´N¬O...¤é´Á·|¦Û°Ê±NªÅªº¤é´Á¦Û°Ê¸É¤W ¨Ã³sÄò...
  ¨Ò¦p¡G¦]¬°¤»¤é¤£»Ý­n§ó·s¡A©Ò¥H5/10 ±µµÛ´N¬O 5/13¡A¦ýG2Åã¥Ü5/13«á¡A·|¦Û°Ê±N5/11¡B5/12¤]¶ñ¤J...
              Åܦ¨5/10
                      5/11
                      5/12
                      5/13
    ½Ð°Ý¦p¦ó¤~¯à±N¶g¥½¦©°£©O¡AÀµ½Ðhcm19522¤j¤j«ü¾É¡AÁÂÁ±z¡I¡I

TOP

¦^´_ 10# hcm19522


    ·PÁ hcm19522 ¤j¤jªº«ü¾É¡AÁÂÁ±z³á¡I¡I

TOP

¦^´_ 10# hcm19522


   ·PÁ hcm19522 ¤j¤j«ü¾É¡I¡I
   ³o¼Ë´N¤£¥Î¤â°Ê§R°£°²¤é¤F¡I¡IÁÂÁ±z¡I¡I

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD