Error Message "Cannot shift objects off sheet" despite no objects

[AG2883]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello all,

Having grouped several rows, i tried to hide them only to be met with the error message: "Cannot shift objects off sheet".

So i looked on various forums and followed the instructions to delete the offending objects: Press F5 / Special / Objects.

However, I was told the sheet doesn't have any objects in it.

Does anyone know how i could resolve this?

Thank you in advance

 

[AG2883]

Just figured it out (well it was on another forum!)

You can only hide a certain number of rows / columns and, in an effort to make my spreadsheet cleaner, I always hide ALL the rows and columns at the end of the sheet that i'm not using.

Once I revealed those, i could hide my grouped rows as i pleased.

(in case anyone was interested)

a