VBA code to copy worksheet and paste as values

**TheTrueVince** · 02-05-2016, 07:42 AM

I need a macro that selects a specific worksheet, copy, then paste as values to a new worksheet.

So when I click on the button of my macro, it would copy the daton from my "Trame" worksheet, and then, create a new worksheet with only the values and the format. This way, if I delete or change the data in the "Trame" sheet, my new sheet won't change anyhow.

Any help would be appreciated.

Vince

Please Login or Register to view this content.

**ranman256** · 02-05-2016, 09:26 AM

you don't need all these error codes

Please Login or Register  to view this content.

**TheTrueVince** · 02-05-2016, 10:08 AM

Hi Ranman and thank you for your answer.

I tried your help but it says "sName" is not define. And I don't see how it can copy only the value and not the formulas. Should't we have to use "PasteSpacial Value" ?

Please Login or Register  to view this content.

**Alf** · 02-05-2016, 10:32 AM

Try adding a Dim statement for sName i.e.

Please Login or Register  to view this content.

To convert formulas to value try adding this line to macro

Please Login or Register  to view this content.

Alf

**TheTrueVince** · 02-05-2016, 10:44 AM

Thank you so much, everything works !!

**Alf** · 02-05-2016, 11:08 AM

You are welcome.

Thanks for feedback and rep

Alf

VBA code to copy worksheet and paste as values

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to copy worksheet and paste as values

Re: VBA code to copy worksheet and paste as values

Re: VBA code to copy worksheet and paste as values

Re: VBA code to copy worksheet and paste as values

Re: VBA code to copy worksheet and paste as values

Re: VBA code to copy worksheet and paste as values

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code for copy and paste values

[SOLVED] Copy/Paste Values Using VBA Code

VBA - Copy Values (from protected worksheet), Open pTemplate.xlsm, Paste Values, Save new

Copy and paste code pasting won't paste just values

[SOLVED] Need Help w/ Code for Copy/Paste data for a Summary Worksheet

[SOLVED] Automatically copy and paste (or update) cell values to another worksheet using VBA code

Need VBA Code to copy paste rows from worksheet to another

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions