Fill-Down Problems! Quick help needed

[Zakkaroo]

I need excel to fill down for me in the following manner:

A2 to A12 all equal 2011-01
A13 to A23 all equal 2011-02
.... 2011-03
etc

All the way up to 2011-53

How can i get Excel to do it without having to type / copy & paste over and over?

 

[MickG]

Try:-

Dim n As Integer
Dim c As Variant
For n = 1 To 53 * 11 Step 11
    c = c + 1
    c = IIf(c < 10, "0" & c, c)
    Range("A" & n + 1).Resize(11) = "2011-" & c
Next n

 

[Zakkaroo]

Perfect Mick, worked great. Really appreciate the quick response.

Job done!