View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Code Numpty Code Numpty is offline
external usenet poster
 
Posts: 94
Default Print specific range but user to select printer

Hi, I have the following in one of my macros to print to the default printer.

Worksheets("Disinfections").Range("pen_list").Prin tOut

How do I change this so that the print dialog box pops up to allow the user
to select the printer and page size?

Happy New Year! (nearly)