I use this code to change the sheet name to what is in the cell;As of now I need to edit the cell (F2) in order for the sheet name to change I need it to be dynamic so I don't have to do the edit Private Sub Worksheet_Change(ByVal Target As Range) 'Change reference cell to the SheetsAddName = cell to this SheetsAdd(After=Sheets(SheetsCount))Name = cell Reply Sage says at 1058 pm That worked even better than expected I had several batches and your new code made the new batches each appear as far right as possible Sage says at 1100 pm Wow, you just saved me an insane amount of boring work
Excel Reference Another Sheet Customguide
