I suspect that you've just used a sledgehammer to crack this nut. Chances are that by accident you made an entry into a cell way, way down on your sheet. Easiest way to find out if that is the case is to go to Print Preview. Excel will, by default, print ALL cells between A1 and the last one that it finds with content. So if preview shows cells outside of the range you thought you were in, then you must have made a 'bum' entry. Out of preview, go to the cell with 'content' (and it could be just a space of course) and delete teh content. That should fix it - without writing macros!!