Help me copy & Paste columns from one sheet to another

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

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

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

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