I have a spreadsheet that I want to keep the focus on just what has been entered. The easiest way, it seems, is to just check to see if the last row + 1 is hidden. If yes, then unhide row and add data. There is one object on the sheet, an image. When I try to all of the rows/columns, from the last filled row (23), an error appears:
"Cannot Shift Objects off Sheet"
Even after removing the image, the error still appears. What's odd is that all of the rows except 1048573:1048576 can be hidden and all of the columns except the one just adjacent to the "Table" can be hidden. I had the Table as a Table, but also converted it back to a normal range with no effect.
I was able to "Fill" those four rows with a color that is similar to the hidden background, but it looks odd when the last row of the table is 23 and the next row is 1048573. Yes, I can keep the rows and column headers from showing, but am curious at why this error is occurring, and what can be done to fix it, instead of just apply a workaround patch .
There have been several suggestions that I found on the net, as far as changing certain settings and/or clearing contents but those haven't helped either.
The other quick question is that it seems that hiding all of the unused rows consumes a lot of memory resources (makes it very slow), would this be correct or could there be something else involved?
Are there any other suggestions?