t*******n
发帖数: 7 | 1 我想COPY WORKBOOK1(WB1)的很多行到 WORKBOOK2(WB2) 上， 请问下面的 CODE 为什么
总有问题, rowD is the row index number. maxrD is the number of rows which will
be copied and pasted. Thank you.
**************************************************************
For rowD=1 to maxrD
wb1.Activesheet.Rows(rowD).Copy
wb2.Activate
ActiveSheet.Cells(rowD+1, 1).Paste
next rowD | r*d
发帖数: 750 | 2 maybe you need to use the method .PasteSpecial
么
will
【在 t*******n 的大作中提到】
: 我想COPY WORKBOOK1(WB1)的很多行到 WORKBOOK2(WB2) 上， 请问下面的 CODE 为什么
: 总有问题, rowD is the row index number. maxrD is the number of rows which will
: be copied and pasted. Thank you.
: **************************************************************
: For rowD=1 to maxrD
: wb1.Activesheet.Rows(rowD).Copy
: wb2.Activate
: ActiveSheet.Cells(rowD+1, 1).Paste
: next rowD
|
|
