• 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


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

Unable to Copy and Paste Excel to Excel

Hi Friends,

i have created a macro for Copy data from excel as "x" and Paste to as "y" with multiple sheets its is working fine
but the issues is if x has only 1 row data some columns are not pasting to y,
if x has >1 row it is working fine can you pls help on this
i enclosed my code in notepad for your reference



Marc L

Excel Ninja
Hi, and doing the same manually, does it work ?​
If yes, go back to initial state and activate the Macro Recorder and redo the same in order to compare with your code …​