Previous Topic Next Topic

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

Closed
SrinivasNittala - 28 Dec 2018 à 07:15
 Blocked Profile - 28 Dec 2018 à 10:16
Hello,

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

1 response

Réponse 1 / 1
Blocked Profile
28 Dec 2018 à 10:16
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

Similar discussions

Working with multiple worksheets in a workbook
buffala77 -
vcoolio -

7 responses
How to copy sheets from one work book to other
Sultaaan -
venkat1926 -

1 response
Copy Worksheet to another Workbook (unopened)
Josh -
Josh -

6 responses
Automatically transfer data from one sheet to another
sunny49er -
TrowaD -

22 responses
Create Multiple Workbooks With Template At Once
Dak903 -
Dak903 -

4 responses