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

[µo°Ý] xlup °ÝÃD..

[µo°Ý] xlup °ÝÃD..

·Q½Ð±Ð¦U¦ì¤j¤j... ¦pªG column C:D ¦³11¦æªº¸ê®Æ..  §Ú·Q§ârange C1:D11 copy¨ì¥t¤@±i¤u§@ªí§@¬°backup...
¦Ócolumn A §Ú¥Î¤FFORUMULA¨Ó¦Û°Ê¶ñ¤W¦~¥÷.. ©Ò¥H¦³¸ê®Æªº¦a¤è·|¥ÑA1¦ÜB21..
½Ð°Ý§Ú­n«ç¼Ë¨Ï¥ÎEnd(xlUp).row ¤~¥i¥H¨ú³Ì«á¤@¦æ¸ê®Æ¬°ROW11¦Ó¤£¬OROW21©O..

ÁÂÁ½ç±Ð!!

xlup.rar (7.28 KB)

¦^´_ 1# jomeow


§Úªº¿n¤À¤£¨¬¥H¤U¸üªþ¥ó¡A©Ò¥H¨Ì±zªºÃD·N¨Ó²q´ú±zªº»Ý¨D¡A¸Õ¸Õ¬ÝÅo!!
  1. Sub test()
  2.     Range("c1:D" & [d65535].End(xlUp).Row).Copy
  3.     Sheets("backup").Select
  4.     [a1].Select
  5.     ActiveSheet.Paste
  6. End Sub
½Æ»s¥N½X

TOP

¦^´_ 3# jomeow
¸Õ¸Õ¬Ý
  1. Sub test()
  2.     Range("c1", [d1].End(xlDown)).Copy Sheets("backup").Range("A1")
  3. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD