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

-
Hello,

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

1 reply

Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1465
-1
Thank you
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

Respond to ac3mark