hi guys i have this macro code
on the last part of my macro i want to put a code that will print my table, my problem is when i put this code
the worksheet is printed using my default printer. i want a code that will print my worksheet using my other printer. thanks
VBA Code:
Range("Table24").Select
Selection.Copy
ActiveSheet.Cells(Rows.Count, 50).End(xlUp).Select
Do While ActiveCell = Empty
ActiveCell.Offset(-1, 0).Select
Loop
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
''put printer macro here
on the last part of my macro i want to put a code that will print my table, my problem is when i put this code
VBA Code:
ActiveSheet.PrintOut
the worksheet is printed using my default printer. i want a code that will print my worksheet using my other printer. thanks