Macro To Print Selected Range

Hi can anyone give me the macro for printing a selection in a sheet?
Thanks

Cross Posted: VBA code conflict

Please read this article on crossposting: http://www.excelfox.com/forum/f25/me...1172/#post5326

The basic code to print the selection is

Code:

---

Selection.PrintOut

---

There are a few arguments you can use to manipulate your print command. One of them being 'Copies'

So if you need 5 copies for example, you could use

Code:

---

Selection.PrintOut Copies:=5

---

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