print area changing size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that replicates a golf score card. VBA code fills in certain data on this spreadsheet. I carefully adjusted the row heights, column widths and font size to exactly match the printer version of the score card. Everything worked fine until something got changed that has changed the absolute dimensions of the printed spreadsheet. I have investigated style changes, font size changes and cannot figure the cause. If anyone has experienced this same problem and determined the cause I would be love to hear about it
 
Just guesses.

Did you change printers. Each printer can print the same data slightly
differently.

Did you do Fit to X page(s) wide by X Tall?

How about Margins (under File|Page setup)?
 
Hi Dave
Thanks for the suggestions but the fit to page is not turned on. I am printing at 100%. The spreadsheet printed on this particular printer before ok. The change was an overall change where the printed area shrunk by a considerable amount. It’s almost like the font size changed. I suspected someone might have changed the style or something like that but that does not seem to be the case. The margins are the same as they were before. I have worked with Excel for a long time but have never encountered this before. I have adjusted everything back so it prints fine now but I am worried that not knowing what caused the problem it may return
Thanks again for your suggestio
 
Back
Top