- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
        
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-12-8 10:45 ½s¿è
¦^´_ 46# 198188
41# ªº¿ù»~¦b- Set Rng(2) = .[A2:L2]
- Set Rng(2) = .Range(Rng(2), .[A2].End(xlDown)) 'AÄæ¨S¸ê®Æ [A2].End(xlDown) ·|¨ìÀɮש³³¡
½Æ»s¥N½X 39# ¤w´£¿ô§A: µ¹§Aªºµ{¦¡½Xn®ø¤Æ¤@¤U,VBA¤~·|¶i¨B-
- Set Rng(1) = .[E2] 'EÄæ¸ê®Æ¦³³sÄò
- '
- '
- Set Rng(2) = .[A2:L2]
- ' **** Set Rng(2) = .Range(Rng(2), .[a2].End(xlDown)) ***** ³o¦æ¤£n¥Î
- Set Rng(2) = Rng(2).Resize(.[E1].End(xlDown).Row - 1)
- '[E1].End(xlDown) ¨ìEÄæ¦³¸ê®Æªº¦a¤è·|°±¤î,¤~¤£·|¨ìÀɮש³³¡
- Rng(2).copy Rng(1).Cells(1, -3)
½Æ»s¥N½X |
|