I did all the normal checks as well as checked the links posted here and
I still have the problem. CTRL+End takes me to the last row. There are
no hidden sheets or very hidden sheets and I deleted all the named
ranges.

More information: When I do print preview, it wants to print A1:D2.
If I copy those eight cells to another worksheet, the problems is
transferred to the new worksheet. I have deleted those two rows as
well as cleared all formatting to no avail. I have since found a work
around (Copy/Paste Special - Formats followed by a Copy/Paste Special
Values to a new worksheet), but I am still curious if anyone knows what
the problem is. My boss and I are Excel experts and I have almost 10
years experience with it, yet we are completely stumped on this.

Thanks for your suggestions,
Tom


--
octobert
------------------------------------------------------------------------
octobert's Profile: http://www.excelforum.com/member.php...o&userid=28163
View this thread: http://www.excelforum.com/showthread...hreadid=476874