SheetName = InputBox("Enter new name for the sheet") For Each ws In ThisWorkbookWorksheets If mySheet = wsName Then wsName = SheetName End If Next ws End Sub Rename a Sheet using Value from a Cell or a Range You can also rename a sheet by taking value from a cell Let's say the value is in cell A11) Put every group on its own page, and 2) name each page using the same field the group uses Step 1 Put each group on its own page To put each group on its own page, open the group's property window Then, in the Page Breaks category, put a check mark in the Between each instance of a group check box Click OK to complete this stepString The name of the sheet view to be created Throws an error when the provided name already exists, is empty, or is a name reserved by the worksheet
1 1 Overview Of Microsoft Excel Beginning Excel First Edition
