I'm All Locked Up

**Karleajensar** · 12-11-2006, 06:05 PM

I'm trying to insert a new column and as soon as I try, I get the perptual hour glass. I can insert columns on other worksheets but this one paticular is giving me fits. Any suggestions on what to look for?

**VBA Noob** · 12-11-2006, 06:22 PM

Hi,

Just after some more info

Do you get an error messages ??

Is it all sheets or just the one ??

How long do you get the hour glass for ??

What is your last used cell ref (Ctrl + End)

VBA Noob

**Karleajensar** · 12-11-2006, 06:29 PM

Just after some more info

Do you get an error messages ?? - No, sir

Is it all sheets or just the one ?? - Just one

How long do you get the hour glass for ?? - I let it sit for 10 minutes before I hit Ctrl-Alt-Del.

What is your last used cell ref (Ctrl + End) - When I hit (Ctrl + End) it went to IV140.

Thank you for your help.

**VBA Noob** · 12-11-2006, 06:35 PM

Your problem is excel only has 256 columns and your reached the limit

That's why it's fallen over

VBA Noob

**MDubbelboer** · 12-11-2006, 06:47 PM

Originally Posted by VBA Noob

Your problem is excel only has 256 columns and your reached the limit

That's why it's fallen over

VBA Noob

while that might be the issue if you have 256 columns of data and try to insert a column you get an error message.

Are there a number of intensive formulas (i.e. sumproducts, countifs, lookups, etc) on your sheet? if they do not need to be active you could "lock" them in place by selecting your sheet, copying, and pasting as values

and as suggested by VBA noob it might be wise to select all the columns to the right of your data and delete them. Do that with the last row and down as well. this way there's no calculations being done in cells that don't need to be.