Excel crashes with "heavy" macros

Not sure what you mean by 'heavy' macros but Excel can handle any length of macro that reasonably can be written. Normally only when you get into Recursive macros that you risk "out of stack" space or some other error. I did notice that your code did not Dimension wb1 and 2 as worksheets.

Get rid of 'Copy' altogether. Instead use 'destinationRange.Value = sourceRange.Value'
This uses much less memory and can greately speed up the code. Especially when you are moving large amounts of data.

Try this:

Please Login or Register  to view this content.

First of all i want to thank everyone for replying. Im going to try what you suggest and get back to you.

I kmow excel can do magic its my macros that i dont know if they are reasonably written. Anyway workbook 1 & 2 are not sheets they are different workbooks. They are both open and i take stuff from one workbook to another.

Originally Posted by EssoExplJoe

Not sure what you mean by 'heavy' macros but Excel can handle any length of macro that reasonably can be written. Normally only when you get into Recursive macros that you risk "out of stack" space or some other error. I did notice that your code did not Dimension wb1 and 2 as worksheets.

This worked perfectly. Thank you.
In the end of the macro though I used one copy/paste for:
Else "to copy the range and paste it to the first empty cell of the other sheet."
But that "value thing" works very quickly, thanks again.