VBA Code not working when inserted with another code.

Application.ScreenUpdating = False
Dim copySheet As Worksheet
Dim pasteSheet As Worksheet
Set copySheet = Worksheets("Monthly Generic Rebate")
Set pasteSheet = Worksheets("Trend")
copySheet.Range("W2:z2").Copy
pasteSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
ChDir "C:\Users\emilvictor.masa\Desktop"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Emil, OpenAfterPublish:=True


but when I am printing it. it seems that the active spreadsheet is not printing.

only 1 sheet.

Instead of ActiveSheet, why not use the variable name of the sheet you want printed.

ok I have normal sheet.

Sheet1 Sheet2 Sheet 3 Sheet 4 Sheet 5

would you be able to code for me?

thanks,

You have copySheet andd pasteSheet as variables. Which one do you want printed. That is the one you need to place instead of ActiveSheet.