previous.copy

  • Thread starter Thread starter Myriam
  • Start date Start date
M

Myriam

Hello everyone,
I have been trying to find some logic to what's going on in a wkbk and I
can't see it.

Using 2003 I created a wkbk with 100+ sheets where users may copy from the
previous sheet by clicking a button w/ the following code.

ActiveSheet.Previous.range("B10:H50").Copy ActiveSheet.range("B10:H50")

It works perfect and it does not slow down the workbook a bit.
I upgraded to Excel 2007 and once I get to the 10 sheet, the macro begins to
run slower and slower until the wkbk eventually crashes.
Any ideas on why this may be happening?
Thanks for any suggestions!
 
It looks like you are at the limits of your memory after a few copies, which
can happen. Instead of copying, why not just assign the values to the range?

ActiveSheet.Range("B10:H50").Value =
ActiveSheet.Previous.Range("B10:H50").Value

Mike F
 
Thanks for your response. I think your solution would work. However, I
changed the macro to yours but it is still slowing down after a few sheet, I
think the memory remained full and I need to clear it. Do you know how I can
clear it?
Regards,
 
Sometimes saving the workbook will clear things out, but it seems that the
multiple copy/paste may not have been the prime issue, so there may be
something else bogging things down.

Mike F
 
Back
Top