Converting all formula in sheet/workbook to current values

[JamieDuncan]

I have a macro that copies a single sheet to a new workbook saves the new workbook and then closes it, but when the new workbook is reopened its cells are still aimed at the original workbook.

Is there a way to convert all formula into their current values before saving, i am guessing it'll appear just after the activesheet.copy line but i dont know how to code this or even if it is possible.

 

[btadams]

you'll probably need to change a line like

Activesheet. Paste

with

Activesheet. PasteSpecial xlValues

 

[Andrew Poulsom]

Something like this?

With ActiveSheet
   .Cells.Copy
   .Cells(1, 1).PasteSpecial xlValues
End With

 

[JamieDuncan]

I didnt know pastespecial worked on formulas too, have used it before to get rid of links,

Thanks very much!