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

lukychien

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

lukychien

¦^´_ 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®É¶¡µ¥«Ýµ{¦¡¤@Äæ¤@Ä槹¦¨
ÁÂÁÂ

lukychien

¥Ø«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

lukychien

¦^´_ 5# freeffly


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

[email protected]

lukychien

¦^´_ 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

lukychien

¦^´_ 8# freeffly


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

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

·PÁ±z