unable to insert a column

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
 
M

Mladen_Dj

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
suddenly can't add row 2
run time error (1004) 2
Unable to Insert Columns 5
Why am I not able to insert a row in my worksheet? 3
Excel won't allow me to insert a row 1
I can't insert column in Excell file! Help please 2
Can't insert columns 1

Top