Need to print sheet one on different printer and sheet 2 on different printer

[Surendra100]

I need to print Sheet 1 on default printer and sheet 2 on different printer. Need VBA code. I Tried to record macro but no luck.

 

[Surendra100]

Sub PrintToNetwork()
ActiveSheet.PrintOut ActivePrinter:="XXXXX"
End Sub

XXXX=is the name of your printer as shown in control panel-Device and printers

 

[vletm]

Surendra100
Modify sheet names and Printers as presents.

Sub PrintToNetwork()
    Sheets("Sheet1").PrintOut ActivePrinter:="XXXXX"
    Sheets("Sheet2").PrintOut ActivePrinter:="XXXXX"
End Sub