Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |