Insert Columns mystery

**jcollins2354** · 02-05-2009, 03:55 PM

"Cannot shift objects off sheet"

Have a large spreadsheet with multiple worksheet tabs, copied from the left. Operations involve lots of cutting & pasting from the "mother" sheet to "daughter" sheets, thus inserting columns, etc. Half of the files have somehow decided they don't accept column inserts?
< error message reads:> "Cannot shift objects off sheet". No insert of course.

What gives? Any experience with this weird error before?

**VBA Noob** · 02-05-2009, 04:02 PM

See if this link helps

http://support.microsoft.com/kb/211769

VBA Noob

**arthurbr** · 02-05-2009, 04:03 PM

Hi and welcome to the board
This probably means that all the sheet's columns are used, so none can be inserted.
You'll have to free some at the end of the sheet

**jcollins2354** · 02-05-2009, 04:46 PM

Thanks especially to arthurbr; it was the columns. When copying worksheets, excel jams columns *with formatting* out to the right. It's the formatting that kills you not columns per se. Deleting a slew of blank but formatted columns did the trick.

regards,

**VBA Noob** · 02-05-2009, 04:48 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save