VBA Quirk?

[normpam]

My code works perfectly on numerous sheets, but on four or five out of maybe 18, it stops and displays an error. Here's the strange thing. Each of the sheets are in the 'page break' view. If I change the view to 'normal' on any of non-working sheets, the code runs just fine! In addition, if I use the 'step mode', I also get no error.

Any ideas? Thanks!

 

[normpam]

No cell protection on the "naughty" sheets ??
Have you tried it on a Dummy workbook to see what happens......worked fine for me in any view !!

Nope. No protected sheets

 

[Michael M]

Nope. No protected sheets

Did you try the dummy workboo