Moving section of cells clears instead!?
 

For the past couple days on the spreadsheet I've been working on if I move
a large section of worksheet cells it moves the borders and comments, but
then completely clears everything else in the block I'm trying to move. It
doesn't clear instantly, but over a couple seconds while the status bar is
very active with numerous quickly displayed messages. The blocks are quite
simple, and one was simply data with no other cells read.

I tried opening with repair, but still the same problem. Just one of the
numerous bugs in Excel? I'm using xl2002.

Don <www.donwiss.com (e-mail link at home page bottom).

Moving section of cells clears instead!?
 

The only reason I can think for behavior like this would be if there are
event procedures firing when you do the move. Is there any code in the
workbook? I am thinking either the worksheet_change or Workbook_SheetChange
event might trigger some code that does something to your data, which would
explain both the disappearing data and the rapid sequence of messages in the
status bar.

"Don Wiss" wrote:

For the past couple days on the spreadsheet I've been working on if I move
a large section of worksheet cells it moves the borders and comments, but
then completely clears everything else in the block I'm trying to move. It
doesn't clear instantly, but over a couple seconds while the status bar is
very active with numerous quickly displayed messages. The blocks are quite
simple, and one was simply data with no other cells read.

I tried opening with repair, but still the same problem. Just one of the
numerous bugs in Excel? I'm using xl2002.

Don <www.donwiss.com (e-mail link at home page bottom).