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