Thanks, but there are no merged cells either...

I did discover that if I'm on one of the sheets with a problem, and I go to
FilePageSetup, and select print preview from there (having made no
changes), that it goes into preview no problem, and prints ok. but If I go
into FilePage Setup and then close the box, and try print preview from the
toolbar, then I get the error message - weird?

Once I've done that, it will then go into preview and print OK - it all
works fine, but I need to do that on every sheet with the problem, EVERY
time this workbook is created.

Any idea what I'm doing wrong, so I can stop it?

Thanks

M

"JLGWhiz" wrote in message
...
Maybe merged cells, either vertically or horizontally.



"Michelle" wrote in message
...
I have a workbook in which I need to print all the pages, with continuous
page numbering...

I can usually select all sheets and print them, but I have some workbooks
that won't even go into print-preview, and get the following error
message:

'Print titles must be contiguous and complete rows or columns'

I know that this can be because of incorrect entries in 'Rows to repeat
at top', or 'Columns to repeat at left' but none of my sheets have
anything at all in either box.

I believe that it can also be because of embedded objects with the wrong
print settings, but none of my sheets contain any objects.

What other reason might I be getting this error?

Any ideas?

Thanks

M