PDA

View Full Version : create a new workbook and then move a sheet to there



uktous
03-13-2012, 08:41 AM
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
03-13-2012, 09:02 AM
This will copy the active worksheet (tab) to a new workbook?

Sub SheetCopy()
ActiveWorkbook.ActiveSheet.Copy
Workbooks(Workbooks.Count).Activate
End Sub


This what you wanted?

Regards
Chris

mancubus
03-13-2012, 09:05 AM
hi.
try..


Sub MoveShtBlnkWB()

Sheets("Sheet3").Move

End Sub