- ©«¤l
- 7
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 10
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 64
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-8-2
- ³Ì«áµn¿ý
- 2019-8-23
|
¤£½T©w®æ¤l¦V¤U¶ñº¡
½Ð±Ð¦U¦ì«e½ú¡A¤p§Ìª¾¹D¦Û¤w¼gªº¥y¤l¡A¥i¥H¦b¦³AÄ榳ȱ¡§Î¤U¡A
¥i¥H¦b§ÀÄæ¤U©Ô¦Û°Ê¶ñº¡
¦ý¬O·|¹J¨ìªº±¡§Î¨Ã¤£¤@©w·|¬O¦bAÄ榳È
¤]³\·|¬O¦bE©Î F©Î¤£½T©w¬YÄæ·|¥X²{²Ä¤@Äæ
¨ú²Ä¤@®æªº¦C = Selection.Row
¨ú²Ä¤@®æªº¼Æ¶q = Selection.Count
With Selection.Resize(Range("A1").CurrentRegion.Rows.Count + 1 - ¨ú²Ä¤@®æªº¦C, ¨ú²Ä¤@®æªº¼Æ¶q)
'³o¤@¥y¤p§Ì·Q¯}ÀY¤]¤£·|~~~½Ð¦U¦ì¤j¤j«ü¾É
.FillDown
ActiveSheet.Range("A1").CurrentRegion.Calculate
.Copy
.PasteSpecial Paste:=xlPasteValues
End With |
-
-
¥¼©R¦W.jpg
(139.18 KB)
|