hi
odd error to get in this situation. usually the error appears when trying to
add columns or rows. the problem is usually because excel has lost it
reference to used range.
see this site. it may help.
http://www.contextures.com/xlfaqApp.html#Unused
regards
FSt1
"SnareHiHat" wrote:
I have a file in which I am trying to hide some data columns. I can do this
successfully across c.30 coulmns and then when I try to hide more or redraw
the column width, I get an error response "Cannot shift objects off sheet". I
have managed to hide all the columns in another file which has exactly the
same number of columns. What trick am I missing?