Printing specific ranges of cells

[fpa93]

Dear all,

I have a worksheet where I read an external barcode and then I set a cell to write the same barcode as the one I have read.

Well, what I need it is a code to print the specific ranges of cells ( or the whole sheet) where the barcode is written right after I read it with the scanner. I mean automatically.

How can I do that? Also, if I have many printers installed in my pc ....with the code can I choose which one I want to print?

Thank you in advance !!

 

[baitmaster]

Change print area to A1:J10

Sub changePrintArea()

With ActiveSheet.PageSetup
    .PrintArea = "$A$1:$J$10"
    .Zoom = False
    .FitToPagesWide = 1
    .FitToPagesTall = 1
    .Orientation = xlLandscape
    .BlackAndWhite = False
End With

End Sub

Select printer:
http://www.mrexcel.com/forum/excel-...l-basic-applications-code-select-printer.html