Unable to Copy and Paste Excel to Excel

[jawaharprm]

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

Thanks
Jawahar

 

[Marc L]

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 …​

​

 

[jolivanes]

If you step through the 1300 lines of code, which line does not work?

 

[jawaharprm]

Hi,

Thanks for your time..
Sorry for delay replay i solved the Problem.