N
nathan
Hello,
I use a macro to copy/paste a small amount data from one worksheet to
another. The worksheet that it copies to seems to have some problem that
steadily gets worse the more I run the macro. First of all the macros runs
slower and slower and now takes about 5 mins. to simply copy/paste a small
amount of data (ie range of A2:B150). Second, when I scroll around the sheet
that is copied TO, it takes a long time for the cursor to pass over a certain
group of cells (ie 3 seconds per cell). this is very frustrating.
I have tried deleting the worksheet and starting with a new one, but the
same problem ends up happening. Seems like it is copying something from the
other sheet and corrupting it...but what?? Any help appreciated.
I use a macro to copy/paste a small amount data from one worksheet to
another. The worksheet that it copies to seems to have some problem that
steadily gets worse the more I run the macro. First of all the macros runs
slower and slower and now takes about 5 mins. to simply copy/paste a small
amount of data (ie range of A2:B150). Second, when I scroll around the sheet
that is copied TO, it takes a long time for the cursor to pass over a certain
group of cells (ie 3 seconds per cell). this is very frustrating.
I have tried deleting the worksheet and starting with a new one, but the
same problem ends up happening. Seems like it is copying something from the
other sheet and corrupting it...but what?? Any help appreciated.
