Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert several Sheets
I need to create a macro that can insert sheets from 01DEC to 31DEC
Each Sheet should be named with each day. Thanks JPG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert several Sheets
Sub addSheet()
On Error Resume Next For t = 31 To 1 Step -1 Sheets.Add.Name = Format(t, "00") & "DEC" Next End Sub "juanpablo" skrev: I need to create a macro that can insert sheets from 01DEC to 31DEC Each Sheet should be named with each day. Thanks JPG |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert several Sheets
"juanpablo" wrote: I need to create a macro that can insert sheets from 01DEC to 31DEC Each Sheet should be named with each day. Thanks JPG |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert several Sheets
"excelent" wrote: Sub addSheet() On Error Resume Next For t = 31 To 1 Step -1 Sheets.Add.Name = Format(t, "00") & "DEC" Next End Sub "juanpablo" skrev: I need to create a macro that can insert sheets from 01DEC to 31DEC Each Sheet should be named with each day. Thanks JPG |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert several Sheets
Hi
Take a look at the sample file I put on ExcelUserGroup.org http://excelusergroup.org/media/p/236.aspx If you want the Month name as well as the day on each sheet it will be easy to amend. -- Regards Roger Govier "supoch14" wrote in message ... "juanpablo" wrote: I need to create a macro that can insert sheets from 01DEC to 31DEC Each Sheet should be named with each day. Thanks JPG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to match and insert info on 2 different sheets | New Users to Excel | |||
Auto insert data to seperate sheets? | New Users to Excel | |||
Insert same picture in multiple sheets and only change once | Excel Discussion (Misc queries) | |||
How many sheets can i insert??? | Excel Discussion (Misc queries) | |||
insert worksheet gives me 3 duplicate sheets not one | Excel Discussion (Misc queries) |