ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't insert columns AGAIN (https://www.excelbanter.com/excel-programming/389391-cant-insert-columns-again.html)

Dean[_8_]

Can't insert columns AGAIN
 
Sorry, but I can't find my old post on a similar problem, but I know that
someone here has the answer, since it gets asked occasionally:

I have a worksheet that ends in column CD and I want to insert some columns
just to the left of CD but it won't let me insert even one, says it will
push stuff off of page. I have cleared everything to the right of CD, so I
know it is empty.

I seem to recall that:

If any cells are merged, it may balk
If there are any objects, such as cell comments, it may balk
Possibly range names that already extend all the way to the right, but I see
none.

I have eliminated all of these, but it hasn't helped. Is there some other
weird thing I've forgotten?

Thanks!
Dean



Dean[_8_]

Can't insert columns AGAIN
 
Actually, after I saved, it works now! So, ignore the question.

Thx,
Dean

"Dean" wrote in message
...
Sorry, but I can't find my old post on a similar problem, but I know that
someone here has the answer, since it gets asked occasionally:

I have a worksheet that ends in column CD and I want to insert some
columns just to the left of CD but it won't let me insert even one, says
it will push stuff off of page. I have cleared everything to the right of
CD, so I know it is empty.

I seem to recall that:

If any cells are merged, it may balk
If there are any objects, such as cell comments, it may balk
Possibly range names that already extend all the way to the right, but I
see none.

I have eliminated all of these, but it hasn't helped. Is there some other
weird thing I've forgotten?

Thanks!
Dean





All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com