J
Jim A
Hi -
I have two identical sheets. One is for "reseting" the other after a user
enters in numbers and wants to reset sheet to its original state. Sheet1 is
for user entry and Sheet2 is the duplicate to copy to Sheet1. They contain
only formulas and conditional formats. The button I use to run the .copy
macro is on rows in Sheet1 that are not in the range of cells copied.
QUESTION: Why when I run the macro several times (copying Sheet2 to Sheet1)
Sheet1 operations get progressively slower to freezing the worksheet
altogether. Even selecting cells refreshes the page very slow. It clocked
at over 14 seconds before it just quit opening Sheet1.
My code:
Set r1 = Sheets("Sheet1").range("A3:AU48")
Set r2 = Sheets("Sheet2").Range("A3:AU48")
r2.Copy r1
What seemed to work better is:
Sheets("Sheet1").Range("A3:AU48").Value = _
Sheets("Sheet2").Range("A3:AU48").formula
But I do not know why...
Can anybody offer an explanation - Thanks - Jim A
I have two identical sheets. One is for "reseting" the other after a user
enters in numbers and wants to reset sheet to its original state. Sheet1 is
for user entry and Sheet2 is the duplicate to copy to Sheet1. They contain
only formulas and conditional formats. The button I use to run the .copy
macro is on rows in Sheet1 that are not in the range of cells copied.
QUESTION: Why when I run the macro several times (copying Sheet2 to Sheet1)
Sheet1 operations get progressively slower to freezing the worksheet
altogether. Even selecting cells refreshes the page very slow. It clocked
at over 14 seconds before it just quit opening Sheet1.
My code:
Set r1 = Sheets("Sheet1").range("A3:AU48")
Set r2 = Sheets("Sheet2").Range("A3:AU48")
r2.Copy r1
What seemed to work better is:
Sheets("Sheet1").Range("A3:AU48").Value = _
Sheets("Sheet2").Range("A3:AU48").formula
But I do not know why...
Can anybody offer an explanation - Thanks - Jim A