Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Printing
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Printing
Resolved · Low Priority · Version 2003
Reply Tue 24 Nov 2009, 16:50Delegate Ian said...
Ian has attended:
Access Introduction course
Printing
What the macro commands for printing a named range?
For upcoming training course dates see: Pricing & availability
RE: printing
Hi Ian
Thanks for your question
You simply need to use the printout method of the range object
Range("MyRange").PrintOut
The method has number of optional arguments allowing you to specify printer names etc. I suggest using VBA's help facility for the details of these
I Hope this is useful
Regards
Stephen
Tue 1 Dec 2009: Automatically marked as resolved.
|