Paste Values exactly as workbook looks

[scruz9]

Hi All,

The current macro I am running below error's out with Run-time Error '1004' To do this, all merged cells need to be the same size. Unfortunately, I don't want to change my merged cells size.

I basically want this macro to paste value and keep all formats as IF I were to do it manually. So that also includes adjusting the macro to encompass: Page View % size for each page, no gridlines (if I don't have any), merged cells as is, and freeze window panes as I have them now.

Is this possible?

Please Login or Register  to view this content.

[bharbir]

Easy fix

Just paste values before you paste format

Please Login or Register  to view this content.