Re: Reduce running time of macro - help appreciated!
Hi Eric and welcome to the forum (and congratulations on a well-presented first post!).
You have already identified the common speed-up measures (Screenupdating and Calculation).
The code could be tidied here and there by assigning some variables to the various objects and using With statements but I'm not sure how much that will help. Have you tried stepping through the code (F8) to try to identify any obvious bottlenecks in execution time? Also, just to give us some context, what size are the worksheets that you are working with (how many rows and columns are currently used)?