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
|Excel Error "Could not load an object because it is not available on this machine"||6||18|
|increment numbers by 10||11||30|
|From msAccess SaveAs an excel file SILENTLY without opening excel||4||30|
|the code is not looping through||11||35|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!