why cut and insert cells only works randomly?
 

It seems that cutting and inserting cells in the spreadsheet, errors every
other time and locks the excell spread sheet...

why cut and insert cells only works randomly?
 

Hi Tony,
You'll have to be more specific, but you might find the answers to such problems
as inserting rows, using OFFSET with formulas. And you will probably find why
extending formulas and does not work for you. -- if any of those are the problem.
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

I don't know what you mean by locking the sheet, have you turned on sheet protection
or have merged cells in your copy..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tony" wrote in message ...
It seems that cutting and inserting cells in the spreadsheet, errors every
other time and locks the excell spread sheet...