| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making for adding and naming a new sheet
Mine was probably NG wrap-around
Worksheets.Add(after:=Worksheets(ActiveSheet.Index )).Name = _ "Inventory " & Format(DateSerial(Year(Date), _ Month(Date) + 1, 1),"mmmm") -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "michaelberrier" wrote in message ups.com... Thanks for the help. Both of those codes return syntax errors I can't find. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming a sheet after a value in a cel of that sheet | Excel Discussion (Misc queries) | |||
| Naming a newly inserted sheet using VBA | Excel Discussion (Misc queries) | |||
| Workbook "Sheet" Naming | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
| Naming Sheets Tabs | Excel Worksheet Functions | |||
Hybrid Mode
