Copy merged cells in Excel

[lauralamlam]

I am having a number of worksheets, same format.
Boss need me to write copy VBA codes and copy those columns to a new worksheet.

I make the excel good -looking, they merged many of the cells in the source worksheet.

Can someone help and advise what i can do?

Thanks

 

[SkipVought]

Welcome to Tek-Tips,

Are you using VBA to copy data to another sheet?

If so, it would be better if you posted your question in forum707.

Please post your VBA code as well.



Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[mintjulep]

What you should do is never merge cells.