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!
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!