Hi everyone,
I had this macro running fine and I wanted to do some additions to it and then it gave me the 1004 run time error.
So I deleted all the extra and went back to this, which is the original (Previously working!) code but I still get the same error
Is there something that I could have done outside of the code to break vba?
Options Explicit
Sub PrintOPMs()
Dim Sh As Worksheet
Dim i As Integer
For Each Sh In ActiveWorkbook.Worksheets
Sh.PrintOut copies:=Cells(2 + i, 2).Value
i = i + 1
Next Sh
End Sub
I had this macro running fine and I wanted to do some additions to it and then it gave me the 1004 run time error.
So I deleted all the extra and went back to this, which is the original (Previously working!) code but I still get the same error
Is there something that I could have done outside of the code to break vba?
Options Explicit
Sub PrintOPMs()
Dim Sh As Worksheet
Dim i As Integer
For Each Sh In ActiveWorkbook.Worksheets
Sh.PrintOut copies:=Cells(2 + i, 2).Value
i = i + 1
Next Sh
End Sub