excel crashing

Hello, After debugging the code I was able to find where the automation error/excel crashes. I believe it is due to the numerous CutCopy modes in the code snippet. How can I make this snippet of code more efficient. I am basically moving a cell from one column to another based on a value. Thank...

Excel Performance Issues Microsoft Excel regularly crashes when working in large workbooks(although this appears to happen in normal sized workbooks) with the Error Message: 'There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory...

Hi All, I have written a macro program which will pull info/data from a text file and save it into an excel sheet. Once this process is done it will run another procedure which will read through the imported data and create shapes (i.e rectangles, connectors, operator shapes...etc.) on the...