Cannot insert column

[sandra]

Trying to insert a column in Excel97 getting message:

To prevent possible loss of data, Microsoft Excel cannot
shift nonblank cells of the worksheet. Try to delete or
clear the cells to the right and below yor data. Then
selectcell A1, and save your workbook to reset the last
cell used. Or, you can move the data to a new location
and try again.

Nothing seems to work and I need to insert another
column. Anyone ever run into this?

 

[Jill]

Sandra,

Can you post the code??????

My guess is that it is not just inserting a column.

 

[Debra Dalgleish]

The following MSKB article may help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?id=211769

Also, Dave Peterson posted this a couple of days ago:
'================
Someone with the same problem posted back that their comments were
getting resized causing the trouble.

Maybe enabling: Tools|Options|View|Comment and indicator
(at least for a little bit will help.)
'========================

Or, perhaps William's suggestion in the following posting will help:

http://groups.google.com/groups?hl=en&selm=#SyiwlGICHA.2580@tkmsftngp09

He advised the following:
'=======================
"if you have a button on your worksheet, right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"
'========================