Button To Print Specific cell Range On One Sheet In Print Selection

[diddy47]

Hello

i am looking for code that when pressed it prints a specif selected range e.g A1 to H41 of the sheet

Would the code be able to make sure "print selection" and "print sheet on one page" options are selected so that the print out is one full A4 page? so that the only user input would be pressing the button

the button could be in a separate column of the same sheet , maybe column J

Regards

[jolivanes]

Please Login or Register  to view this content.

[diddy47]

Hello, thank you for your reply, when the code was implemented it printed out a blank page. I tried to change the Sheet1 reference to match the sheet name of the sheet in question (custom named AlwaysShow). The error.... Runtime error 9, Script out of range

[jolivanes]

Attach your workbook without personal data.

[saravnepali]

Ensure that the range you want to print is NOT BLANK and also that sheet name exists on the workbook.

This is one that will trigger Runtime error 9, otherwise code seems straight forward and runs properly.

[jolivanes]

If the Button is on the sheet that you want to print and the Range you mentioned in your first Post has data, like saravnepali mentioned, you can use

Please Login or Register  to view this content.

[diddy47]

thank you .....got it working now, silly mistake

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.