run time error (1004)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top