Don't know how you want it set up, but would any ideas here help? Later
versions of Excel make this faster.

Sub Demo()
Dim Months(1 To 12) As String
Dim Start As Long
Dim Mth As Long

Start = 10 'October

For Mth = 1 To 12
Months(Mth) = MonthName(((Mth + Start - 2) Mod 12) + 1)
Next Mth
End Sub

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


wrote in message
...
hi...

I want to run a loop such that if the starting value is
oct then my array arrMonth() should start with OCtober or
OCt and the remaining 11 months be filled automatically...

is it feasible?

thanks a lot