Hello, i am wondering if there is a way that when copying a sheet into a new workbook, and the sheet i am copying has formulas. Is there a way to do this and not have the references in the formula of the new workbook when bringing the copy over?
Here is the code i use to make the tab in the new workbook.
Here is the code i use to make the tab in the new workbook.
VBA Code:
'Create new template
Set wbNew = Workbooks.Add
Set wsNewTemp1 = wbNew.Worksheets("Sheet1")
wsNewTemp1.Name = "Calculation"
ThisWorkbook.Sheets("Calculation").Range("A1:EW1").EntireColumn.Copy
wsNewTemp1.Range("A1").PasteSpecial Paste:=xlPasteAll
