I have a macro that copies a tab with formulas and pastes values/formats/column widths to replicate it in another workbook without formulas. However, I need to get the new tab into a print-ready format but the coding I have right now is not doing the trick.

There are only two columns that need to be printed and currently there is a page break after the first column, however, I need it to be after the second. The original tab is already formatted this way, but the print format is not being carried over in the "paste special > formats" process. Also, after checking the results of the code I am using, it seems that nothing changes. What am I doing wrong here?

Thanks!