This will do the trick:

Sub CopySheet()
Sheets("Sheet1").Copy ' copies Sheet1 to a new workbook
End Sub

--
Ole P.

RobG wrote:
Hi all

I need a simple macro to export one worksheet, including formulae, values
and all formating, to a new workbook. Can anyone help me?

Rob