Copy and paste formulas from a workbook to another without reference with VBA

[brendalpzm]

I have 3 workbooks, one of them (wb1) has a vba code that copies some formuled cells (a1:c23) in a worksheet from wb2 and copies them in a worksheet in wb3.

The thing is that the formulas copied in wb3 are referencing the wb2 instead of wb3, how to copy without this reference?

 

[Peter_SSs]

Does this do what you want (after checking/editing workbook and worksheet names)

Sub Copy_Formulas()
  Workbooks("wb3.xlsx").Sheets("Sheet1").Range("A1:C23").Formula = Workbooks("wb2.xlsx").Sheets("Sheet1").Range("A1:C23").Formula
End Sub