Thread: Paste as values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
  
Posts: 312
Default Paste as values
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)
Reply With QuoteReply With Quote