View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default copy rows and paste in another workbook

Hello people,

Id like to construct a macro that copies all rows from the workshett I am
working in (copy the whole lenght of the row just as leftclicking the 1st row
number and holding and draging down until the last row with data is
selected), and then copying it to workbook2, sheet2 row2 , just as
rightclicking and chosing insert copied cells would. any suggestions?

Thank you in advance.