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

[µo°Ý] ¤U©Ô¤½¦¡¦p¦ó­×§ï¬°¦Û°Ê§PÂ_³Ì«á¦C

[µo°Ý] ¤U©Ô¤½¦¡¦p¦ó­×§ï¬°¦Û°Ê§PÂ_³Ì«á¦C

½Ð°Ý¦U¦ì«e½ú¡A§Ú¨Ï¥Î¿ý»s¥¨¶°
¨ä¤¤¦³¤@¬q¬O±NL2ªº¤½¦¡¡A­n¥N¨ì³øªí³Ì«á¤@¦C¡A¦ý¨C¦¸³øªíµ²§À¤£¤@©w¬O¦P¤@¦C
½Ð°Ý­n¦p¦ó¼gµ{¦¡¦Û°Ê§PÂ_

Range("L2").Select  '¿ï¨úL2ªº¤½¦¡
Selection.AutoFill Destination:=Range("L2:L25921")   '¤U©Ô¤½¦¡¨ìµ²§À
Range("L2:L25921").Select

³o¥y¹Á¸Õ§ï¦¨End(xlDown)¡A¦ý¬O¥¢±Ñ¡AÁٽЫe½ú«üÂI ÁÂÁÂ
Selection.AutoFill.End(xlDown).Select   '¤U©Ô¤½¦¡¨ìµ²§À
Range("L2:L25921").Select                        '³o¥y¬O¤£¬O­n¸òµÛ­×§ï?©Î¨ú®ø¡A¤£¥Î¿ï¨ú

½Ð°Ý¦U¦ì«e½ú¡A§Ú¨Ï¥Î¿ý»s¥¨¶°
¨ä¤¤¦³¤@¬q¬O±NL2ªº¤½¦¡¡A­n¥N¨ì³øªí³Ì«á¤@¦C¡A¦ý¨C¦¸³øªíµ²§À¤£¤@©w¬O¦P¤@ ...
abc9gad2016 µoªí©ó 2022-6-14 14:55


¥Ñ¤U©¹¤W§ì¨ú³Ì«á¤@¦C¡AÁÂÁÂ
R= [L65536].End(xlUp).Row

TOP

¥»©«³Ì«á¥Ñ lpk187 ©ó 2022-6-15 04:29 ½s¿è

¬JµM¦³³øªíµ²§À¡A¨º´N¥Hµ²§À¨º¤@Äæ¥h§ä¥X³Ì«á¤@¦C¡A¨Ò¦p¥i¥H§ä¨ì³Ì«á¤@¦C¸ê®Æªº¬OKÄ樺´N¦p¤U¡G
     endRow = Cells(Rows.Count, "K").End(xlUp).Row'§ä¨ì³Ì«á¤@¦C
     Range("L2").AutoFill Destination:=Range("L2:L" &  endRow) '§â³Ì«á¤@¦C¼Æ¾Ú³sµ²¨ì¥y¤l¤¤
    Selection. ¡B  .Select ³£¬O¤£¥²­nªº

TOP

¬JµM¦³³øªíµ²§À¡A¨º´N¥Hµ²§À¨º¤@Äæ¥h§ä¥X³Ì«á¤@¦C¡A¨Ò¦p¥i¥H§ä¨ì³Ì«á¤@¦C¸ê®Æªº¬OKÄ樺´N¦p¤U¡G
     endR ...
lpk187 µoªí©ó 2022-6-15 04:22



    ·PÁ¤j¤j §Ú©ú¥Õ¤F!!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD