Copy worksheet from one workbook to another workbook in MS Office Excel [Closed]

Report
-
 Blocked Profile -
Hello,

In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.

1 reply


Check for its existance with:

Function sheetexist(whatsheet)
On Error GoTo NotExists

ThisWorkbook.Worksheets(whatsheet).Select
sheetexist = True
Exit Function

NotExists:
sheetexist = False

End Function