Formatting Several Sheets
I have one sheet that serves as an menu to name several new sheets in
my workbook. I would like to add to this code. I need Range("a3") on each NEW worksheet to contain a heading from the same list. It would say, "Regional Office 325 2008". The "325" for the header would come from the sheet.name. Any ideas? Sub copyCleanTemp() Dim rngName As Range Dim i As Integer Set rngName = ThisWorkbook.Sheets("RegDivList").Range("e2") Do Until rngName.Value = "" i = ThisWorkbook.Sheets.Count Sheets("CleanTemp").Copy After:=Sheets(i) ThisWorkbook.Sheets(i + 1).name = rngName.Value Set rngName = rngName.Offset(1) Loop End Sub |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com