how do I paste ONLY values from one sheet to another

Hello!

So...here's the issue, I need to copy a range of cells on one worksheet and paste them in another while maintaining the formatting of the second worksheet.

This doesn't work....I'm not sure why but I get the error message "Select method of range class failed"

Please Login or Register  to view this content.

And this doesn't maintain the formatting...

Please Login or Register  to view this content.

Any thoughts?

Thanks so much!!

Hi, It might be failing because the new sheet isn't active. Try

Please Login or Register  to view this content.

It might also be a problem with accessing a different sheet with a Private Sub, try making the Sub Public in the first Book.

I tried this. I created Book2 and Book3 and formatted Cell C6 in Book3 with the different format to Book 2. I then entered dummy data into B3 in Book 2, copied the cell and used paste special to past the values into Book 3, Cell6 and the new formattng was preserved. The range D12 has the default Book3 formatting and when the data is pasted in using the same method, the default Book3 formatting is preserved. Substitute your filenames and ranges in the code below.

Please Login or Register  to view this content.

Hope this works for you.

noclass1980