Run Time Error in Macro

[TooZippy]

I have this macro in two different files. It runs in the first one but when I run it in the second one I get a "Run Time Error" message asking me to debug. I moved things around in the print area and this error message came up when I ran the macro. It was working fine before I moved things around.

I changed the row numbers in the macro to correspond to where it is supposed to print out after I moved things around. In the second file I have a formula that pulls the number printed out from the first file and adds to it the number printed out in this file. Here is the macro...

Sub PrintCheck()
'
' CheckPrinting Macro
'
   Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")
   Dim num As Integer
   Range("N8, N28, N46").Select
   num = Range("N8, N28, N46").Value
   num = num + 1
   Range("N8, N28, N46").Value = num


End Sub

The line in the code that I made bold is the area that shows up yellow in the macro when I go to debug.

Thank you,

 

[RoryA]

What is the actual error message?

 

[TooZippy]

RoryA Thank you for responding to my question. I got some help outside of MrExcel that solved my problem. When I moved the cells in the print area I did not change the format from Locked to Hidden so when I protected the sheet the macro could not complete the instructions. Thank you anyway. TooZippy