Thread: copy paste loop---new to vba
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default copy paste loop---new to vba
why not
rows("2:66").copy sheets("yoursheet").rows(2)


--
Don Guillett
SalesAid Software

"MFR" wrote in message
...
need to create a loop that copies each row to a different sheet. . . . .
.row2 to sheet(2).range (A2), row3 to sheet(3) range (A2) etc. from
a single worksheet.



Reply With QuoteReply With Quote