你的问题不是很清楚,你没有回答澄清问题...
如果您想在“数据”表的末尾插入,请使用下一个代码:
xx = toString( '-' + toString( x ) + '-' );
z = i.replace( /\-1\-/gi,xx );
如果您想在特定行上插入复制的范围,请使用下一个变体:
Sub Add_Button()
Dim Summary As Worksheet,data As Worksheet,lastRD As Long
Set Summary = Worksheets("Summary") 'use here your real sheet
Set data = Worksheets("Data") 'use here your real sheet
lastRD = data.Range("A" & data.rows.count).End(xlUp).row + 1 'last empty row
data.Range("A" & lastRD).Resize(1,4).Value2 = Summary.Range("A21:D21").Value2
End Sub
要将值粘贴到第一个空行中,请使用此行:
Sub Add_ButtonX()
Dim Summary As Worksheet,insertRow As Long
Set Summary = Worksheets("Summary") 'use here your real sheet
Set data = Worksheets("Data") 'use here your real sheet
insertRow = 20 'rows on which to insert copied data
Summary.Range("A21:D21").Copy
data.Range("A" & insertRow).Insert Shift:=xlDown
End Sub
本文链接:https://www.f2er.com/1246.html