Copy worksheet from one workbook to another workbook in MS Office Excel

SrinivasNittala - Updated on Dec 28, 2018 at 08:27 AM
 Blocked Profile - Dec 28, 2018 at 10:16 AM

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

1 response

Blocked Profile
Dec 28, 2018 at 10:16 AM
Check for its existance with:

Function sheetexist(whatsheet)
On Error GoTo NotExists

sheetexist = True
Exit Function

sheetexist = False

End Function