Print range using macro

**nbuk** · 06-28-2010, 01:51 PM

Hello,

I am still new to programming in excel and I need some help figuring out how to print.

I want to add a button to one of my worksheets with a 'print' macro attached. What I need help with is writing the macro.

I have a table which has 1 hour time intervals on A3:A26 and 1 day increments on B2:NC2.

When the user clicks the print button they will be asked to enter the start date. Based on that start date a table will be printed for one week, starting with the start date. Also, I need to print the times on the left of the table which are in A3:A26. Therefore, I need to print 2 ranges on one sheet.

Can anyone please help me figure out the code. I have been looking online but the code fragments that I did find were very complicated and I did not understand them.

Thank you for the help.

**royUK** · 06-28-2010, 01:54 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**nbuk** · 06-28-2010, 02:16 PM

Because this project is for work, I cannot post the full workbook but I have attached the worksheets which will need to be printed.

The print button will be located in a different sheet, but in the same workbook. When the user enters the date, all of the tables in the file need to printed for the next 7 days from the entered date, including the left hand column with the times. Each table should be printed on its own sheet.

I hope this makes my problem more clear.

Thank you.