• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

paste cells twice

A

aleksandra123

New Member
Hello

I am struggling with macro to copy cell A1 in column let's say A and paste to cell A1 and A2 in another column in another worbook. Then macro should come back and repeate copying but with cell A2.

Thank you for any tips!
 
Hi !

Just activate the Macro recorder then operate manually :
you will get your own free code base !

And smarter than copying cell by cell is copying block of cells !
A must read : Range.Copy method in VBA inner help …
​
 
You must log in or register to reply here.
Back
Top