run time error (1004)

[Guest]

Hello:

When I try to insert a column I get this message.

"To prevent possible loss of data, Microsoft Excel cannot shift non blank
cells off the worksheet. Try to delete or clear cells to the right and below
your data .then select cell A1, and save your workbook to reset the last cell
used. Or, you can move the data to new location and try again.

This happens only with certain workbooks .The workbooks are identical. Is
there something I could do? I tried inserting a column using a macro and it
still does not work. I get a run time error (1004).

Thanks,

Ravi

 

[Guest]

Hi ravi,

Sounds like you have used up your columns. Press <End><Home> and see where
your cursor ends up. If you are not using all the columns to the left of
this position, select the columns between where your cursor ended up and the
actual last column used, delete them, save the file and try inserting again.

 

[Bob Phillips]

Ravi,

See is these help


http://support.microsoft.com?kbid=170081
XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel

--

HTH

RP
(remove nothere from the email address if mailing direct)