Print range using macro

**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.