Hi Daniel,
Do you have any comments on your sheet? If you do, Click on Edit
Comment, then right click the comment box. Go into Format
Comment...Properties. Make sure that "Don't move or resize with cells"
is NOT selected (so it can move)
regards
Paul

"Daniel Bonallack" wrote in message ...
Hi, I'm really hoping someone can help, as I'm stuck.

I have a worksheet that has sales data going up to about
row 61000, and across to column BC.

I have some simple code that highlights the area and
subtotals by company name (about one thousand companies),
which adds another 1000 rows to the data.

Then I try to click on the little "2" in the top left
corner, in order to just see my company totals. The
message I get is "Can't shift objects off sheet". Does
anyone know why this is occuring? I've made sure that
there is no data in the last 3000 rows of the spreadsheet,
and as far as I know those cells have no formats either.

Thanks in advance
Daniel