vba printing

I am looking for a VBA Code that can be used to print to a specific printer on 11x17 sheet in landscape orientation and print area based on the dynamic print area that i have already set up. I have tried recording a macro but can only get it to print to last used printer. Can anyone help?

hello I am trying to come up with a way to print a selected group of worksheets through a command button the selected group of worksheets will change weekly The worksheets that will print will be named as zip codes IE: 01001, 01010, 01030...ect I thought maybe...on a worksheet... in column...

I have an excel Workbook with multiple sheets. I am trying to figure out the code in vba to print two specific worksheets to pdf or straight to the default printer, duplex (Sheet 1 on front and sheet 2 on back. Any help would be appreciated.

Hi, Trying to write a code that will trigger a command button to print out sheet "ClientInput", but only print cells with data. I have tried plenty of different variations of code, but they always seem to either print one page only, or print 2600 pages (I have formulas that will only produce...

I am needing to print multiple pdf files by file name that is in a list. These files will be in the same folder as the excel file. For example MMR1234, MMR1235, MMR1236 and stop on next blank cell. Then I am needing it to close Acrobat after printing.

Hi All. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am new to VBA and I have been using the recorder to learn as well as this site however certain situations really stop me in my tracks. Your help would be greatly appreciated. <o:p> </o:p> I have a...