Printing Hidden Cells

[andrewb90]

I am sure this is pretty simple, but I am unsure how to do this. I would like to create a button to print out certain cells, most of which are hidden. How do I go about doing this?

Thanks,

Andrew

 

[andrewb90]

So I figured out how to adjust the code for my columns, but is it possible to have a macro that will print out lines from different pages?

Thanks,

Andrew

 

[Michael M]

Firstly,how many rows on which sheets ?
What are the rows you want printed ?
Do you want them printed seperately or as a group ?
Are they copied to any other location ?

 

[andrewb90]

I would need B66:B115, DEF66:DEF115, G66:G114, BDEFG154, also a few single cells: E2, G6:G7, B6:B9. That would be the info I would want to print when looking at the weekly report. It is the info from each day during that week, and they would all be on separate sheets. Each page that it would print form is titled for the day of the week: MON, TUE, WED, THU, FRI, SAT, SUN. The info is not completely duplicated anywhere else, although column G which is the totals is copied onto the weekly page where I would like to have the button with the assigned macro.
Hope this helps!

Thanks!
Andrew