Thread: Cut&Paste Macro
View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

Wouldn't it be easier to delete the rows first and then copy

--
Don Guillett
SalesAid Software

wrote in message
...
I need a Cut and Paste macro which will cut every second row (A2,A4,
etc) and Paste them to a destination (E1,E3, etc) one by one.

So A2 will be cut and pasted to E1, A4 to E3, etc etc. For the range
A2 to A100. If you can add an option to delete rows 2, 4, 6 etc after
the process it will also be appreciated.

TIA

JK