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

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.
--
ve_2nd_at. Randburg, Gauteng, South Africa


"ravi" wrote:

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

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)


"ravi" wrote in message
...
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