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

[µo°Ý] ¦p¦ó½Æ»sÄæ¦ì¤½¦¡

[µo°Ý] ¦p¦ó½Æ»sÄæ¦ì¤½¦¡

½Ð±Ð¦p¦ó½Æ»s¼Æ­ÓÄæ¦ìªº¤½¦¡¡C
½Æ»sA1:E1ªº¤½¦¡¨ìA2:E2¡A¨C°õ¦æ¤@¦¸¡A«K¨Ì§Ç¦V¤U½Æ»s¤@¦¸¡C
ÁÂÁÂ

¦^´_ 1# lukychien
°é¿ïA1:E1½d³ò«á¦A©¹¤U©ì¦æ½Æ»s§Y¥i¡A¤£ª¾±zªº°ÝÃD¦b­þ¡H¥i§_¦A¤©¸Ô­z°ÝÃD¥H¨Ñ¾Ç²ß¡H

TOP

¦^´_ 2# p212

¤p§Ì©ú¥Õ°é¿ï«á¦V¤U©Ô§Y¥i¡A¦ý¥Ñ©óÄæ¦ìªº¼Æ¶q«Ü¦h¡A¤£·Q¥Î'¤â°Ê'¡A©Ò¥H·Q½Ð±Ð¦p¦ó¥ÎVBA§¹¦¨
¥Ø«e¤p§Ì¥u·|¥Î³æ¤@Äæ¦ì½Æ»s¡A¦ý¥Ñ©ó¼Æ¶q«Ü¦h¡A»Ý­nªá«Ü¦h®É¶¡µ¥«Ýµ{¦¡¤@Äæ¤@Ä槹¦¨
ÁÂÁÂ

TOP

¥Ø«e¨Ï¥Îªº¤è¦¡¦p¤U...

Range("A1048576").End(xlUp).Select
Selection.Copy
Range("A1048576").End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False

TOP

¦^´_ 4# lukychien


    ¥Îautofillªº¤è¦¡(¤U©Ô¶ñº¡)
   §Ú¦b2003¬O¥Î³oºØ¤è¦¡
   §A¥i¥H¥Î¿ý»sªº¤è¦¡
   µM«á¥h­×§ï
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 5# freeffly


¤p§Ì¤£¬O«Ü©ú¥Õ­n¦p¦ó¾Þ§@¡A¥i§_½Ð±zµy¥[»¡©ú©Î±H¹q¶lµ¹§Ú°Ñ¦Ò
ÁÂÁÂ

[email protected]

TOP

¦^´_ 5# freeffly


·PÁ±zªº´£¥Ü¡A¥Ø«e±Nµ{¦¡­×§ï¤§«á¤v¸g¥i¥H½Æ»s¼Æ­ÓÄæ¦ìªº¤½¦¡¤F¡C·PÁÂ!!

Range("A1048576").End(xlUp).Select
Range(Selection, Selection.End(xlToRight)).Copy
Range("A1048576").End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False

TOP

¦^´_ 7# lukychien


    §Úªº¤è¦¡¤£¬O³o¼Ë
   ¬O2¼Ó»¡ªº
   §A¥i¥H¥Î»¡©ú¬d¬Ý¬Ýautofill³o¦Uªº»¡©ú
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 8# freeffly


¤£¦n·N«ä¡A§Ú¬O¬Ý¤F§Aªº¦^À³¤§«á¡A¬ðµM·Q¨ìªº...

Ãö©ó Autofill ªº³¡¥÷¡A§Ú·|¦A¬ã¨s¬ã¨s

·PÁ±z

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD