Copy without the format of the cell, so only value

Hi

I got this code but now I don't succeed in copying just the values.

Please Login or Register  to view this content.

So in the Worksheet where I copy I need only the values of the cells.

Please help

does it fail (on what line) or does it run and nothing happens?

It works but it copies the color of the source cells

How about

Please Login or Register  to view this content.

Works perfectly

Only one more thing

After clearing contents I would like the first row of ("Lijst Fiches") to be copied to ("Zonder Gevolg"). It is my header

Rather than clearing the entire sheet use

Please Login or Register  to view this content.

Thanks, really so simpel, been couple of years

You're welcome & thanks for the feedback

Please Login or Register  to view this content.

Now I would like to do this three times but only the first Sub does it as it should. The rest doesn't copy everything.

Solved it, sorry for the spamming

Please Login or Register  to view this content.