Printing several ranges on one sheet

**nbuk** · 06-25-2010, 02:26 PM

I'm new to VBA and I never worked with any printing options.
Can someone help me with the code required to print 2 different ranges on one sheet?

**Leith Ross** · 06-25-2010, 04:20 PM

Hello nbuk,

I am not sure if you are asking how to copy 2 ranges to a new sheet and print the sheet or print any 2 columns of an existing sheet. It would help if you post your workbook.

**nbuk** · 06-25-2010, 04:37 PM

I have a macro which automatically generates 12 different schedules. The schedule has the capacity to store information for a year (schedule for 361 days). I need to be able to print it based on the day the user inputs.

Ex: user inputs 6/15/10 then a schedule needs to be printed from 6/15/10 to 6/29/10.

The reason I need to print 2 ranges is to add a column with times as it will most likely not be near the range of the schedule the user wants to print.

I hope that makes sense.

Thanks for the help so far.

**Leith Ross** · 06-25-2010, 04:52 PM

Hello nbuk,

Could you post a sample worksheet?

**alinashath** · 07-08-2010, 03:07 AM

Can anyone help me on setting a printing option where i can select a range on the sheet when I wanted to make a printout of that region. example region A with one option and region B with another option.