Autofill Dilemma

T

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
 
D

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
 
Top