Thank you both for your quick response. Both the print preview (Don's code) and the automatic print (Greg's code) worked, but neither hid the columns. I reproduced what you both did on a new "practice" sheet, and they both worked great. I'm wondering if the problem on my gradesheet is that the bottom rows contain formulas for calculating class averages, as well as min./max scores for each assignment? I tried both codes on a "clean" gradesheet template from Microsoft. They both worked on one that had no formulas at the end of the sheet, but not the other

A1:AH - Student names, averages, assignments, etc

A60-63:AH60-63 - Class summary inf