Had that problem a couple of times.

Try selecting all the blank columns to the right of your data and then
deleting them, sometime the blank cells might have a format on then.
Then try inserting your new column.

That's only worked for me a couple of times though.

the alternative is copy the data into a new workbook, that usually
works.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=395826