Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - right click clears selected cells | Excel Discussion (Misc queries) | |||
Macro ?-moving info from 1 sheet to first blank section on another | Excel Discussion (Misc queries) | |||
Entry into one cell clears other cells | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Formula for moving a row into another section of the Worksheet | New Users to Excel |