Paste as values

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)
 
R

Ron de Bruin

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
 
Top