Excel VBA error 400 while link to another sheet

[Jagat Pavasia]

Dear sir,
I have 2 Sheet in my excel workbook.
First sheet name is "Account" and another name is "Print".
I have put Below VBA in sheet named "Print"

Sub Print_Jangad()
'
' Print_Jangad Macro
'

'
    Set mynetwork = CreateObject("WScript.network")
    mynetwork.SetDefaultPrinter "Brother QL-800"
    Application.PrintCommunication = False
    With ActiveSheet.PageSetup
        .PrintTitleRows = ""
        .PrintTitleColumns = ""
    End With
    Application.PrintCommunication = True
    ActiveSheet.PageSetup.PrintArea = ""
    Application.PrintCommunication = False
    With ActiveSheet.PageSetup
        .LeftHeader = ""
        .CenterHeader = ""
        .RightHeader = ""
        .LeftFooter = ""
        .CenterFooter = ""
        .RightFooter = ""
        .LeftMargin = Application.InchesToPoints(0)
        .RightMargin = Application.InchesToPoints(0)
        .TopMargin = Application.InchesToPoints(0.196850393700787)
        .BottomMargin = Application.InchesToPoints(0)
        .HeaderMargin = Application.InchesToPoints(0)
        .FooterMargin = Application.InchesToPoints(0)
        .PrintHeadings = False
        .PrintGridlines = False
        .PrintComments = xlPrintNoComments
        .PrintQuality = 300
        .CenterHorizontally = False
        .CenterVertically = False
        .Orientation = xlLandscape
        .Draft = False
        .PaperSize = 329
        .FirstPageNumber = xlAutomatic
        .Order = xlDownThenOver
        .BlackAndWhite = False
        .Zoom = 100
        .PrintErrors = xlPrintErrorsDisplayed
        .OddAndEvenPagesHeaderFooter = False
        .DifferentFirstPageHeaderFooter = False
        .ScaleWithDocHeaderFooter = True
        .AlignMarginsHeaderFooter = True
        .EvenPage.LeftHeader.Text = ""
        .EvenPage.CenterHeader.Text = ""
        .EvenPage.RightHeader.Text = ""
        .EvenPage.LeftFooter.Text = ""
        .EvenPage.CenterFooter.Text = ""
        .EvenPage.RightFooter.Text = ""
        .FirstPage.LeftHeader.Text = ""
        .FirstPage.CenterHeader.Text = ""
        .FirstPage.RightHeader.Text = ""
        .FirstPage.LeftFooter.Text = ""
        .FirstPage.CenterFooter.Text = ""
        .FirstPage.RightFooter.Text = ""
    End With
    Application.PrintCommunication = True
    Range("A35:F44").Select
    Selection.PrintOut Copies:=1, Collate:=True
    Set mynetwork = CreateObject("WScript.network")
mynetwork.SetDefaultPrinter "Samsung SCX-3200 Series"
End Sub

And I put link of command button in sheet named "Account" and click on it,
then I got Error 400.

If i put link of command button in sheet named "Print" and click on it then it work as I want.
But I want to put command Button in sheet "Account".


what can i Do ?

 

[rollis13]

The quickest way would be to add: Sheets("Print").Activate at the beginning of the macro and: Sheets("Account").Activate at the end of it so that the reference is to the right sheet while the macro creates the printed page.
But, even with this addition, I get error #400 on this line: .Papersize = 329. I must say that I cannot use this paper size with my printer. Therefore, if I use a standard paper size the macro does not generate an error any more; so check that parameter too.

 

[Jagat Pavasia]

The quickest way would be to add: Sheets("Print").Activate at the beginning of the macro and: Sheets("Account").Activate at the end of it so that the reference is to the right sheet while the macro creates the printed page.
But, even with this addition, I get error #400 on this line: .Papersize = 329. I must say that I cannot use this paper size with my printer. Therefore, if I use a standard paper size the macro does not generate an error any more; so check that parameter too.

Did you edit macro and then send me ?
Because i have record vba and create this VBA.
I am a new in VBA .

Please, thank you in advance

 

[rollis13]

This is the first line (beginning) of your macro: Set mynetwork = CreateObject("WScript.network")
and this your last line (end): mynetwork.SetDefaultPrinter "Samsung SCX-3200 Series".
So just Copy/Paste what I said in the first sentence of my post #2.
Then, if you still get Error #400 delete the line I indicated in the second sentence of post #2.