Hi

Right-click on sheet tab, select 'Move or Copy...', into 'To book' field
select '(new book)', check 'Create a copy', and press OK.

When you want a macro, switch 'Record new Macro' from ToolsMacro menu
before. When finished, stop the recording, and probably you have to edit it
afterwards to ensure it works from any active sheet {replace any part of
code containing something like 'Sheets("YourSheetName")' with 'ActiveSheet',
etc.}

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"RobG" wrote in message
...
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