Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 300
Default 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).
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - right click clears selected cells Michelle Excel Discussion (Misc queries) 4 April 28th 09 04:39 PM
Macro ?-moving info from 1 sheet to first blank section on another carrera Excel Discussion (Misc queries) 6 March 12th 08 08:19 PM
Entry into one cell clears other cells bkala Excel Discussion (Misc queries) 1 November 30th 07 09:58 PM
Arrow Keys Moving Window Frame instead of Moving Between Cells nemmex Excel Discussion (Misc queries) 2 April 9th 07 09:08 AM
Formula for moving a row into another section of the Worksheet Scottm New Users to Excel 2 March 14th 07 04:53 PM


All times are GMT +1. The time now is 04:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"