View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
funkymonkUK[_40_] funkymonkUK[_40_] is offline
external usenet poster
 
Posts: 1
Default 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?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=380817