Macro to print a selection!

B

Bob Vance

What macro would I need to : Print(A18:K155) ?

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
F

Frank Kabel

Hi Bob
....
Range("A18:K15").Select
Selection.PrintOut Copies:=1
....

works on the active worksheet.
HTH
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Macro to select and delete levels of a document 2
Need Help with Macro Security 1
Printing Outline view - formatting lost 0
Select Text to End of Footnote 9
Blank Page After Envelope-Label Wizard 5
Improving Macro That Keeps First Letter 0
Page numbering with Merged Document and IF statements 1

Top