ããå
å½å¶å®ï¼å¿«æ·é®æå®ä¸ºctrl+shift+rï¼åæ¢å½å¶å®ï¼ç¶åæå¼VBAç¼è¾å¨ï¼æåæå½å¶çå
容å é¤ï¼è¾å
¥ä»¥ä¸å
容ã
ããDim IRow As Long, i As Long
For i = 1 To 4
IRow = ActiveCell.Row
Rows(IRow + 1).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("a" & IRow + 2).Activate
Next i
ããæåè¾å
¥ä½ æ³è¦è®¾ç½®çæ¶é´ä¿åå°±å¯ä»¥äº ã
温馨提示:答案为网友推荐,仅供参考