I copied each worksheet to a new workbook. There are 12, one for each month.
I then cut and pasted to a blank workbook without incident.

I then attempted to see what would happen if I did that from the original
workbook, and I got the same error, no surprise there. However, then I tried
to cut and paste from the new workbook and got the same error. This was a
surprise.

The 12 worksheets contain a lot of formulae and up until now have not given
me any trouble. Do you, hopefully, have any other ideas on why this is
happening or what I can do to fix this?

Is my attempt to use the original workbook causing the new one to fail as
well?

Thanks for your assistance.



"Dave Peterson" wrote:

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