View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default cutting and pasting rows from one sheet to another generates error

I think it's time for some detective work.

If you start two new workbooks and do the same type of cut|paste, do you have
trouble.

If no, then it might not be excel (the program).

Maybe the sending workbook is getting corrupted. I had a similar problem where
I couldn't move a worksheet--but I could copy the worksheet (not the cells--the
whole worksheet).

I rebuilt that worksheet (yechhh!) and all things went back to normal.

Maybe it's time to recreate that worksheet (or workbook?).

JT Spitz wrote:

Excel 2000
I have a worksheet that has six non contiguous rows that I need to move to a
new worksheet.

Every time I cut and paste from the original worksheet to the new one it
generates errors and closes Excel. It states it is generating an error log,
that I can't see. Please note I am doing this one row at a time, rather than
picking up all six rows at once. This also happens when I group the six
together and then try to paste the six at once.

It does let me copy the information and then go back to the original and
delete the rows, so I can accomplish what I need, but it seems that this is
an inefficient use of Excel.

Any help in determining what the problem is would be appreciated.
Thank you.


--

Dave Peterson