After Macros is broken, formatting is not the same

[thewiseguy]

Hi everyone,

I had an issue with a macro in my workbook, which is now resolved. However, I can not get the margins, headers and overall formatting of my document back to the way it was. I've re-created it, tried it from another version of excel, even a different pc but the margins are just not 100%. Has anyone ever seen this? Or have any ideas on how to fix it?

Any help is appreciated.

 

[thewiseguy]

The zoom is the same on both worksheets. The issue is not with the actual stated row heights, as they are the same on both worksheets, but when the file is printed, they are not the same.

The capture image attached shows both worksheets. You can see the rulers on the left-hand side of the worksheets are not the same. Each individual row height is the same but the ruler does not equal. A simple way to explain it, is that an inch on 1 worksheet is not equal to an inch on the other.

Also, I ensured the margins are the same as well.