Thread: Copy contiguous from one sheet and paste to another every other ro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Dean is offline
external usenet poster
  
Posts: 93
Default Copy contiguous from one sheet and paste to another every other ro
I am trying to write a macro that copies from Sheet1 contiguous data A1:A30
and paste data to Sheet2 to every other row (ie Sheet1.A1 to Sheet2.A1;
Sheet1.A2 to Sheet2.A3; Sheet1.A3 to Sheet2.A5 and so on). The pasted result
is data with blank cells in between. Thanks in advance.
Reply With QuoteReply With Quote