Fri 18 Sep 2009, 16:31Delegate Natasha said...
Natasha has attended:
Excel VBA Intro Intermediate course
Print file using macro
how do I get a macro to print a file
Tue 22 Sep 2009, 09:36Trainer Stephen said...
RE: print file using macro
Hi Natasha
Thank you for your question
To print a worksheet you should use the printout method of the sheet object
For example
ActiveSheet.PrintOut The printout method has a number of optional arguments that can be used to specify default printers, number of pages, number of copies etc.
If you type the above line of code into the VBE, select PrintOut and press F1, you will see the detailed help for the method
Regards
Stephen
