Copy worksheet to new workbook : Values & Formats

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

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.

"Franck" <[email protected]> wrote in message
news:[email protected]...
> 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
>