||
‘VBA复制一行,行号用变量表示
Sheet1.Range(Sheet1.Cells(j, 1), Sheet1.Cells(j, 104)).Copy Destination:=Sheet2.Range(Sheet2.Cells(i, 1), Sheet2.Cells(i, 104))
Worksheets("sheet1").Rows(i).Copy Worksheets("sheet2").Cells(k, 1) #将sheet1的一行复制到sheet2中的第k行
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-5-21 23:37
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社