Hi Marc. One thing I would like to add to your script.
In range C:E I have formulas with absolute references. So, would it be possible to copy them as values? Right now, when I use your macro, it copies the name corectly but adds only "0" values.