Try this idea
Sub fillnumbersmod()
j = 1
For i = 1 To 12 Step 5
Cells(i, "a").Resize(5) = j
j = j + 1
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Imagine in Excel you have A1 = 1

A6 = 2

A11 = 3

This is for this weeks data, next week value 2 could be in A7 or A10
or A12 etc.

I want to have the flexibility to fill down from e.g. this week from
A1 to A5 and fill A6 to A10 will a 2 etc.

How can I do this? I can't seem to get the range flexibility, thanks.