Printing an area (A1:I272) on a different sheet than the "Print" button is on

**cmsandiford** · 09-04-2014, 10:31 AM

I am trying to print an area using a VBA but cant seem to find any help on the subject (I don't know if this is common or not or probably am not asking the right question).

I have created a "Print" button on the "Input" sheet and would like for it to print a range "A1:I272" from the "Output" sheet.

How do I go about doing this?

THANK YOU!

Also, may be more advanced or may need to post this in a separate post but...

Could I have a dialogue box pop up when I ask it to print and have check boxes for what all ranges the user wants printed?
I can go further into detail on this one if the first question gets answered I guess

**HaHoBe** · 09-04-2014, 11:58 AM

Hi, cmsandiford,

one way might be:

Please Login or Register  to view this content.

Regarding the additional question;: you would need to specify the ranges you want to be printed/selected. But I would prefer to hgave a different thread on that question.

Ciao,
Holger