Add the routine at the end of your code to

SELECT ALL
COPY
PASTE SPECIAL, VALUES only.

I do not remember the exact coding sequence for above, but if you record a
macro and then do the above steps, Excel will show you what to do.
Sir Metro