Page 1 of 1

Macro to Automate Print for Excel

Posted: December 13th, 2006, 10:26 am
by chicagotypewrite
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!

Macro to Automate Print for Excel

Posted: December 13th, 2006, 10:33 am
by cemil
Firstly define the each print area. And make a sub to print these selected area

Macro to Automate Print for Excel

Posted: December 13th, 2006, 10:45 am
by chicagotypewrite
Have found the answer to the problem. Thanks for reading.