problem when inserting or deleting cells

HI I have a workbook which i am trying to either insert individual cells or entire rows/columns and get the following message:

To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells of the worksheet.

Try to delete or clear the 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 a new location and try again.

(OK BUTTON)


What is this error message for and how do I get rid of it?

what it means i sthat you haev data in column IV so that when you insert a
column, the data in IV will be shifted off....
either make sure that the last column is empty or try

Application.DisplayAlerts = False


"funkymonkUK" wrote:

>
> HI I have a workbook which i am trying to either insert individual cells
> or entire rows/columns and get the following message:
>
> To prevent possible loss of data, Microsoft Excel cannot shift nonblank
> cells of the worksheet.
>
> Try to delete or clear the 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 a new location and try again.
>
> (OK BUTTON)
>
>
> What is this error message for and how do I get rid of it?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=380817
>
>

Thanks that helped me, what i found was all the cells were hidden except a1:x44
now what had happened as in the hide rows the back ground colour as chosen right up to column IV therefore everytime I inserted row/cloumn it would bring up this error.

I then just formatted the cells involved as no background and it works great now thanks a lot