Copy Worksheet

[reklamo]

I want to copy one worksheet to another open workbook with VBA.
I want the user to select any of the open workbooks to copy the worksheet to.
How can I call the dialog "Move or Copy Sheet..." from VBA?

Thanks for your help
reklamo

 

[Gary''s Student]

Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

 

[reklamo]

Thanks, it's working

Regards
reklamo

Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

 

[Gary''s Student]

Thanks for the feedback.