create a new workbook and then move a sheet to there

[uktous]

Hi,

I want a macro that can perform the following function.

Step1: Create a new workbook.
Step2: Move a certain worksheet to that workbook.

Could you please write me the marco?

thanks

[wrightyrx7]

This will copy the active worksheet (tab) to a new workbook?

[VBA]Sub SheetCopy()
ActiveWorkbook.ActiveSheet.Copy
Workbooks(Workbooks.Count).Activate
End Sub
[/VBA]

This what you wanted?

Regards
Chris

[mancubus]

hi.
try..

[VBA]
Sub MoveShtBlnkWB()

Sheets("Sheet3").Move

End Sub
[/VBA]