Does anyone know a way to add a named worksheet to an excell workbook using excell. Right now, i am using Sheets.Add which will add whatever the next sheet in the count is. I.E. SheetX. Which I then need to re-name to "TempPrint"
I would like to be able to add a sheet named "TempPrint" without going through the steps of adding a sheet and re-naming it