Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can not shift objects off sheet error
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
Getting an error message "Cannot shift objects off of sheet" | Excel Discussion (Misc queries) | |||
Error: Can't Shift Objects off Sheet | Excel Discussion (Misc queries) | |||
Excel Error Message: "Cannot shift objects off sheet" | Excel Discussion (Misc queries) | |||
Can not shift objects off sheet error | Excel Programming |