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.