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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Steph" wrote in message om...
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)