Hi can anyone give me the macro for printing a selection in a sheet?
Thanks
Hi can anyone give me the macro for printing a selection in a sheet?
Thanks
Last edited by ciapul12; 11-15-2013 at 03:43 PM. Reason: cross posting
Cross Posted: VBA code conflict
Please read this article on crossposting: http://www.excelfox.com/forum/f25/me...1172/#post5326
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
The basic code to print the selection is
There are a few arguments you can use to manipulate your print command. One of them being 'Copies'Code:Selection.PrintOut
So if you need 5 copies for example, you could use
Code:Selection.PrintOut Copies:=5
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
ciapul12, please do not disregard the importance of proper cross-posting. inappropriate language and behavior towards fellow users (public or private) is uncalled for.
http://www.excelfox.com/forum/infrac...infractionid=1
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks