Optimize a large inefficient macro

Hey Guys,

I have a fairly big macro below and wondering if it can be optimized to be faster or better, I'm sure there are mistakes in my code below which can make it significantly faster especially regarding the replacing formulas into values...

The code I am using is too big for the forum so I've put it on pastebin: http://pastebin.com/raw.php?i=NvN280Qj


Thanks in advance
- Hyflex