Paste values and format

**cmb80** · 06-19-2014, 10:50 AM

Please advise if it is possible to adapt VBA code to paste values and formats

My current code does just the values as below

Please Login or Register  to view this content.

**Norie** · 06-19-2014, 10:53 AM

Either this,

Please Login or Register  to view this content.

to copy values and number formats, or this.

Please Login or Register  to view this content.

to copy all formatting.

**TMS** · 06-19-2014, 10:56 AM

Please post the rest of your code and, ideally, a sample workbook.

Regards, TMS

Re: Paste values and format