Create and copy new sheet

Question

Newbie here, I have a template sheet with a table containing formulas.At the end I want to press a button to create and copy-paste values from template sheet to the new sheet so here is what i got: Sub CreateSheet() Dim xName As String Dim xSht As Object Dim xNWS As Worksheet On Error Resume Next xName = Application.InputBox("Please enter a name for this new sheet ", "New Sheet") If xName = "" Then Exit Sub Set xSht = Sheets(xName) If Not xSht Is Nothing Then MsgBox "Sheet cannot be created as there is already a worksheet with the same name in this workbook" Exit Sub End If ActiveSheet.Copy after:=Sheets(Sheets.Count) Set xNWS = Sheets(Sheets.Count) xNWS.Name = xName End Sub Problem is I just want to Paste Values without any formulas from template sheet Thanks JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You could go for a solution that would create an empty sheet manually and use PasteSpecial with option xlPasteValuesto copy only values - but this would not copy the formatting. You could then use another PasteSpecial to copy the formatting. An alternative is to first copy the whole template as you do, including formulas, and add the following statement. It looks odd at first, but it converts all formulas into values. xNWS.UsedRange.Value2 = xNWS.UsedRange.Value2