Copy worksheet to new workbook : Values & Formats

F

Franck

Hi,
Is it possible to cpy an entire worksheet (Values & Formats) to a new
workbook without copying formulas ?

Sheets(X).Copy is building links to previous workbook.

Thks for help
 
M

Mladen_Dj

After coping go to Edit->Links, and break links, and excel will replace
links with values.
If you do it from VBA, which seems so, try with PasteSpecial metod.
 
Top