Archive of Mr Excel Message Board
Back to Errors in Excel archive index
Back to archive home
error message when inserting lines
Posted by mabaud on July 17, 2001 1:41 AM
Why do i get the following message when I try to insert a line:
"To prevent loss of data, Microsoft Excel cannot shift non-blank cells....
Try to delete...
Or you can move...."
What is the problem ?
thanks
Re: error message when inserting lines
Posted by Ivan F Moala on July 17, 2001 2:02 AM
You probably have data weatther that be True data
or a formated cell or a cell with something in it
@ or near the Row or column limits. Excel displays
this msg if you insert rows/cols that will cause
these cells to be placed over the row/col limit
Rows = 65536 / cols = 255.
Check your sheet for errant data or formating
near these limits.
Ivan
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.