Skip to content

Instantly share code, notes, and snippets.

@paulobunga
Last active December 6, 2019 14:54
Show Gist options
  • Save paulobunga/878aecfb23c213f5dbe41f849f165ad8 to your computer and use it in GitHub Desktop.
Save paulobunga/878aecfb23c213f5dbe41f849f165ad8 to your computer and use it in GitHub Desktop.
Sub Create()
'Updateby Extendoffice 20160704
Dim I As Long
Dim xNumber As Integer
Dim xName As String
Dim xActiveSheet As Worksheet
On Error Resume Next
Application.ScreenUpdating = False
Set xActiveSheet = ActiveSheet
xNumber = InputBox("Enter number of times to copy the current sheet")
For I = 1 To xNumber
xName = ActiveSheet.Name
xActiveSheet.Copy After:=ActiveWorkbook.Sheets(xName)
ActiveSheet.Name = "KTE-" & I
Next
xActiveSheet.Activate
Application.ScreenUpdating = True
End Sub
@paulobunga
Copy link
Author

Press Alt F11

Press F5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment