ExcelBanter - VBA paste with formatting?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA paste with formatting? (https://www.excelbanter.com/excel-discussion-misc-queries/161901-vba-paste-formatting.html)

pokdbz

VBA paste with formatting?

I am trying to copy a range of cells and paste the values and formatting.

When I paste it, it just pastes the values and does not include the
formatting for each cell.

Thanks

All times are GMT +1. The time now is 02:19 PM.