Copying and pasting values only

**Quintin** · 08-13-2015, 09:15 AM

Good day,
I have a excel workbook that I am able to push a button to copy a worksheet and it creates a new worksheet and saves it and closes it.
the problem I have is that I am try to have it only paste the values and not the formulas, so that if you opened it on another pc, you are able to read it
as the values.
Find attached the code I have been using - many thanks.

Note that I have tried putting .PasteSpecial Paste:=xlPasteValues in different areas, but has not worked.

Please Login or Register  to view this content.

**mchilapur** · 08-13-2015, 09:56 AM

Before you copy the range, better select it first. Then key-in below code

Please Login or Register  to view this content.

It basically removes all formulas in the range.

Then you can copy only the values and paste it where ever you want..

**Quintin** · 08-13-2015, 10:12 AM

Many thx, I'll give that a try

**mchilapur** · 08-13-2015, 10:20 AM

Always welcome...Please let me know the end result..

Copying and pasting values only

LinkBack

Thread Tools

Rate This Thread

Display

Copying and pasting values only

Re: Copying and pasting values only

Re: Copying and pasting values only

Re: Copying and pasting values only

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copying values from a column and pasting into a row.

copying and pasting cell values

Copying and Pasting Unique Values

copying & pasting multiple values from one sheet to another

Copying and Pasting values

Copying formalua and Pasting as values

copying values and pasting the same value on multiple cells

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions