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 

Your reply

1 reply

Posts
11185
Registration date
Monday June 3, 2013
Status
Contributor
Last seen
January 22, 2019
1917
0
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