Paste as values

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Hello. Below is a snippet from some code I have. How do I modify
this to paste values, so the formula doesn't carry through. Thanks!!

wkbk.Sheets("Opex & CAPEX").Copy After:=ThisWorkbook.Worksheets(1)
 
Hi Steph

When you copy the sheet the new sheet is the Active one.
This macro will make values of all cells in that new sheet

With ActiveSheet.UsedRange
.Value = .Value
End With
 
Back
Top