Print Macro

[Shinod]

Dear All,

Sub Printt()
ActiveSheet.Range("B1:I43").PrintPreview
End Sub

This code is allowing me the print preview. But from here, I'm not getting an option to select the printer. How it can make possible?

Also would like to get another macro for direct print with this range in A5 size, portrait, A5 printer (That is the printer name)

 

[Dan_W]

Hi - this post shows you how to export a range to PDF, along with the different settings you might want: VBA - save specific range as PDF
This thread shows you how you can select a printer if you to: Printing: VBA code to select printer
Hope that helps.