Macro to Automate Print for Excel

chicagotypewrite · December 13th, 2006, 10:26 am

Hi,I wanted to build a macro whereby Excel will select certain sheets and print them, all in one step. However, when I tried running the macro, it didn't work, and the code itself doesn't have anything about printing either. Would appreciate if you could shed some light on this matter, thanks!

cemil · December 13th, 2006, 10:33 am

Firstly define the each print area. And make a sub to print these selected area

chicagotypewrite · December 13th, 2006, 10:45 am

Have found the answer to the problem. Thanks for reading.