I have a worksheet with column headings and data that I want to add a print button for users to be able to print their report displayed on the screen to the printer that is set as their default. This worksheet expands all the way to column CD but I just want the print to focus on a specific range Columns A : S. Some reports will be long some will be short but I want the pages printed to depend on the length of the report. The last row of data in column H can be used to determine the length of the report. What vba code can I use for this task so I can assign a Print command button to it. Thanks in advance. The report should have the following specifications.
Landscape
Print 1 Page Wide
Header=0.3
Footer=0.3
Top=0.6
Bottom=0.6
Left=0.6
Right=0.6
Gridlines should be checked