Sheet / Page Copy With İnput Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub inputsheetcopy() Dim TBName$, WBName$ TBName = InputBox("Blattname:") If TBName = "" Then Exit Sub WBName = InputBox("Dateiname:") If WBName = "" Then Exit Sub Worksheets(TBName).Copy ActiveWorkbook.SaveAs WBName ActiveWorkbook.Close End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 sheet / page copy with input 2 Adding and naming sheet / pages with inputbox 3 sheet / page copy (with macro) 4 inserts months as sheet / pages Specifies days in detail 5 specify the number of copies to print from the printer 6 Inputbox add year as summer 7 excel operators hk 8 a copy of a sheet / page (specify its name) 9 add sheet / page write name to inputbox 10 add sheet / pages 11 number of sheet / page prints with message box (prints even if the sheet / page is blank) 12 summer adds months to sheet / pages 13 you specify the sheet / page copy 14 search find copy to other sheet / page 15 output as a word sheet / page 16 set name save and close active sheet / page as book 17 Go to sheet / page with Inputbox 18 Finding sheet / pages with Inputbox 19 to assign a value to another sheet / page without selecting a formulated cell 20 sheet / page copy (copies the sheet / page with index name 2 c6 by deleting the buttons)