Hello!
This is the functionality I would like. First the user clicks a command button, which will let them name the sheet that they will create, then copy a certain range of the current sheet into the new sheet keeping its formatting. What I have tried (code):
It unfortunately does not work. Any help or assistance would be greatly appreciated! Thank you!
This is the functionality I would like. First the user clicks a command button, which will let them name the sheet that they will create, then copy a certain range of the current sheet into the new sheet keeping its formatting. What I have tried (code):
VBA Code:
Private Sub CommandButton1_Click()
Dim val As String
val = InputBox("Enter the configuration name for the current selection")
Sheets.Add(After:=Sheets(Sheets.Count)).Name = val
Worksheets("Feed Configurator").Range("A108:M109").Copy Worksheets(val)
End Sub