Hi Dave,
It means you have data down in the last permissible row of the spreadsheet
(65536 in XL97). If you insert a row it moves all rows below it down one.
This it cannot do in this case without loosing data. Cutting and
moving/pasting would avoid this.
Hope this helps
Paul
-----Original Message-----
From: Dave Stewardson [mailto:[log in to unmask]]
Sent: 19 February 1999 17:17
To: [log in to unmask]
Subject: Error message
Dear Assumers
Can anybody help with this curiosity?
Thanks.
Forwarded message reads:
Subject: Error message I don't understand
From: "Juliet Schick" <[log in to unmask]>
Hello just had a request from a user that she could't insert a row
into Excel - the message was:
Cannot shift nonblank cell off sheets
I got round the problem by cutting and moving the rows but would be
interested to know why the insert wouldn't work - I assume there was
some unusual formatting.
TIA
Juliet
End forwarded Message
Regards
Dave Stewardson
ISRU {Industrial Statistics Research Unit}
MMME {Department of Mechanical, Materials and Manufacturing Engineering}
Stephenson Building
University of Newcastle upon Tyne
Tyne & Wear
England
GB - NE1 7RU
TEL 00 44 191 222 8513
FAX 00 44 191 222 8600
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|