lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
If I run the code below, it will create a file with the copied sheet. What is the interpretation of that? why excel doing that if a user did not specify after or before? Thank you very much.
If I run the code below, it will create a file with the copied sheet. What is the interpretation of that? why excel doing that if a user did not specify after or before? Thank you very much.
Code:
Sub copysheet()
'to copy a sheet
Dim x As Integer
x = InputBox("enter sheet#")
Workbooks(1).Worksheets(x).Copy
End Sub