It works like a champ.
I had a good  feeling as I was entering the code..
.. there was even a tool-tip for the "xlPasteFormulas".

And znapp .. thanks for your suggestion, but
all that did was to copy  the value, not the formula.