Excel 2007 - Print Titles Must Be Contiguous and Complete Rows and Columns

[dollarbill13]

I have a macro that I use to combine about a hundred worksheets into one excel workbook. When I try to Print or Print Preview the workbook, I get an error saying "Print Titles Must Be Contiguous and Complete Rows and Columns". If I simply go to Page Setup > Sheet and then click "OK", I'm able to then Print or Print Preview. However, I'd prefer to not have to go through that process for each of my sheets. I've tried running a VBA loop to set the Print Errors as blank (as seen below) but it doesn't seem to have any affect. Any ideas?

For x = 1 To ActiveWorkbook.Sheets.Count Step 1
With ActiveSheet.PageSetup
.PrintErrors = xlPrintErrorsBlank
End With
Next x

 

[dollarbill13]

Also, I don't actualy have any print titles set up. The only thing I have is a print area which is set as "C10:Q606". Seems contiguous to me... ?