Previous Topic Next Topic

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

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

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

1 response

Answer 1 / 1
Blocked Profile
Dec 28, 2018 at 10:16 AM
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 Value from new Workbook to existing Workbook
classermild -
ac3mark -

1 response
auto row copy to another worksheet
barryhall -
Anon -

8 responses
Automatically transfer data from one worksheet to another
vamus21 -
vcoolio -

1 response