第3个回答 2019-12-24
加个按钮
定义四个变量a,b,c,d as integer
a=sheet1.usedrange.rows.count,
b=sheet1.usedrange.colounms.count.
c=sheet2.usedrange.rows.count,
d=sheet2.usedrange.colounms.count.
然后用个循环
for h=1 to a
for i= 1 to b
sheet2.cells(c+a,d+b)=sheet1.cells(a,b)这样不改变原来表二的数据,把表一的数据全部复制过来