Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I copied this macro from one of the e-mail correspondences but somehow when I
run same it errors out with "sub or function not defined". This macro is suppose to create worksheets given a certain YEAR. The debugger is stopping at the "Application.StatusBar = D" Sub MakeYear() Dim SH As Worksheet Dim D As Date, Y As Long Set SH = ActiveSheet Y = Val(InputBox("Year:")) If Y < 2000 Then Exit Sub If Y 2100 Then Exit Sub Application.ScreenUpdating = False For D = DateSerial(Y, 1, 1) To DateSerial(Y, 12, 31) Application.StatusBar = D SH.Copy after:=Sheets(Sheets.Count) ActiveSheet.Range("A1").Value = D ActiveSheet.Name = Format(D, "mmm dd") Next Application.StatusBar = False Application.ScreenUpdating = True End Sub Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i calculate what i make in a year into an hour? | Excel Worksheet Functions | |||
how to make a rolling calender where hours roll off after a year | Excel Discussion (Misc queries) | |||
how do I make changes in several worksheets at once? | Excel Worksheet Functions | |||
how do I make changes in several worksheets at once? | Excel Discussion (Misc queries) | |||
How would I make a calendar template in Excel for the year 2006?? | Excel Worksheet Functions |