unable to insert a column

  • 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
 
Check which is last cell in book. Pres F5, and select "Special"-> "Last
Cell", and look is there any in last column (values, formulas or formats),
posibly you have there some residual data or formats. Than you can delete
all columns between last and range of your data.
 
Back
Top