Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Printing

Printing

ResolvedVersion 2003

Tue 24 Nov 2009, 16:50 Delegate Ian said...

Ian has attended:
Access Introduction course

Printing

What the macro commands for printing a named range?

Wed 25 Nov 2009, 11:02 Trainer Stephen said...

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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy