Kamelortk

This can easily be done by editing the code Sheet Naming Rules in Excel When renaming a sheet in Excel, there are some naming rules you need to follow A sheet name can be a maximum of 31 characters in length You can not leave a sheet name blank You can not have two sheets of the same name All table names ( in the excel sheets) are to be read dynamically How do i read unknown table/Sheet name from the excel template, i have upto Sheets? Let's see the VBA code that we are using to rename the old sheet name in excel The is code is as follows Sub ChangeSheetName (SheetOldName As String, SheetNewName As String) Sheets (SheetOldName)Name = SheetNewName End Sub How To Get Sheet Name Of Worksheet In Excel Sheet name code excel footer