printing macro

[JasonLeVan]

I am looking to make a macro that will will print 3 pages if cell b103 contains data, 2 pages if cell b49 contains data and just one page if neither contain data

 

[JPM]

Are you looking for something like this?

Sub Macro1()
If Range("B103") <> "" Then
ActiveWindow.SelectedSheets.PrintOut Copies:=3
Else
If Range("B49") <> "" Then
ActiveWindow.SelectedSheets.PrintOut Copies:=2
Else
End If
End If
End Sub