Copying and pasting worksheets into new worksheet as values

**MikeFranz123** · 05-03-2012, 05:10 AM

Hi everyone,

I'm trying to copy several sheets from one workbook to another, which I've managed to do, but unfortunately it is paste formulas, not values.
Here is the code I'm using:

Please Login or Register  to view this content.

Any help would be appreciated!

Thanks

Mike

**arlu1201** · 05-03-2012, 05:22 AM

In the above code, you are making a copy of the sheets, hence its directly copying the data as is.

You might need to change the code to copy the contents individually into the destination file. By doing that, you will be able to paste special values.