Actually, I got myself turned around in my initial response. Try Ctrl+End
and see what row you end up in. You may have something in the last possible
row (possibly a space in a cell). Also see if, by removing several rows, you
can add subtotals.

"RealGomer" wrote:

I have a spreadsheet that, after running Subtotals from the Data menu,
returns the error message "Cannot shift objects off sheet" when I try to
condense the spreadsheet. There are no comments on the spreadsheet. I
selected all cells and pressed "Delete". The susbtotal range is below any
text. After running Subtotals, there are a total of 2,374 roows. What gives?
--
I know enuff to be dangerous.