Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
Sub Macro3() 'I am starting the process with a cell selected that 'will become the new sheet tabs name. I copy the cell 'and Ln3 is the paste into the sheet tab rename. Sheets.Add After:=Sheets(Sheets.Count) Sheets("Sheet3").Select 'will be different each time Sheets("Sheet3").Name = "120-2758" 'will be different each time Sheets("ReadMe").Select ActiveCell.Rows("1:1").EntireRow.Select Application.CutCopyMode = False Selection.Delete Shift:=xlUp End Sub
Join the community of 500,000 technology professionals and ask your questions.