### when you print

[eluna]

Is there a way to automatically adjust the columns so when they print, ###### do not show. I have several sheets that values change constantly and need to be print in one page per sheet.

Thanks

 

[Zack Barresse]

Hello there eluna,

Yes, this is possible. That means 1 of 2 things, either 1) your data does not fit within the alloted column width or 2) you have negative time values. If it is caused by reason 1, you can use something like this ...


<font face=Tahoma New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_BeforePrint(Cancel <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Boolean</SPAN>)
    Cells.EntireColumn.AutoFit
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>


With the file open, directly to the left of the File menu item, right click the little workbook icon and select View Code. Paste the code in the right pane. Note that only one Before_Print event is allowed per workbook, so if you already have one they will need to be merged.

Note that you should already know about how this will impact your sheet. If you have columns that autofit to a very large area you may have some funky results when you print.

 

[eluna]

Very helpful. Thanks a lot