Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
previous.copy
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
previous.copy
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 "Myriam" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
previous.copy
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, "Mike Fogleman" wrote: 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 "Myriam" wrote in message ... 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! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
previous.copy
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 "Myriam" wrote in message ... 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, "Mike Fogleman" wrote: 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 "Myriam" wrote in message ... 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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find last row and copy previous row data | Excel Worksheet Functions | |||
copy previous row down 5 rows | Excel Programming | |||
Need A Macro To Copy Previous Tab to New Tab | Excel Discussion (Misc queries) | |||
copy from previous page | Excel Programming | |||
add rows with copy format of previous row | Excel Programming |