I have a macro that copies and pastes rows, depending on various conditions. The problem is, it takes ages, which in itself is fine, however during the running of it, I cannot copy and paste anything on any other application. Also I have heard that using copy and paste is not very efficient.
Can anyone give me examples of how I could improve my code below?
The 2nd example does update sheet 3, but the macro still runs.
Please Login or Register to view this content.
To look at improving efficiency, I'd need to look at your workbook; if you post it up I'll take a look at it for you. MM.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
I would love to post my spreadsheet however it's all data imports and macros, plus the actual workbook in it has lots of person identifying data in it.
I have attached a scaled down version of the workbook and the only macro conerned is as follows (All my macros are in the PERSONAL.XLS file)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks