Help me copy & Paste columns from one sheet to another

[gm2612]

Hello experts,

I have a work book in which I have two sheets named "Temp" and "New". From "Temp" sheet, I need to copy columns A to R and paste it with same format and cell width to sheet "New"

Can you please provide me VBA Codes for the same?

Thanks and the help.

With regards,
gm2612

[AB33]

Please Login or Register  to view this content.

[AB33]

Or

Please Login or Register  to view this content.

[gm2612]

Helo Guru,

I am using first method, format gets copied. But, error message pops up in the line [ActiveSheet.Range("A1").PasteSpecial xlValues]

Can you please help resolving it?

Thanks a lot
regards,
gm2612

[gm2612]

AB 33,

Many thanks for the support. I have rectified the error. I was mixing it with another another macro. But, later I recognized what I was doing.

Your code works excellent. Thanks for the help.

Regards,
gm2612