Autofill Dilemma

[toby83]

I would like to autofill 1,2,3,4,5 etc. in a column but I only want
number every 48th row i.e.

1



47 rows inbetween




2

Apologies if this is rather simple, but I am too!

Many thanks

Tob

 

[Don Guillett]

modify this to suit. change the 10 to the last one you want and 3 to 48

Sub numbermod()
For i = 1 To 10 Step 3
Cells(i, 1) = i
Next i
End Sub