I would like to autofill 1,2,3,4,5 etc. in a column but I only want a number every 48th row i.e.
1
47 rows inbetween
2
Apologies if this is rather simple, but I am too!
Many thanks
Toby
I would like to autofill 1,2,3,4,5 etc. in a column but I only want a number every 48th row i.e.
1
47 rows inbetween
2
Apologies if this is rather simple, but I am too!
Many thanks
Toby
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
--
Don Guillett
SalesAid Software
[email protected]
"toby83" <[email protected]> wrote in
message news:[email protected]...
>
> I would like to autofill 1,2,3,4,5 etc. in a column but I only want a
> number every 48th row i.e.
>
> 1
>
>
>
> 47 rows inbetween
>
>
>
>
> 2
>
> Apologies if this is rather simple, but I am too!
>
> Many thanks
>
> Toby
>
>
> --
> toby83
> ------------------------------------------------------------------------
> toby83's Profile:
> http://www.excelforum.com/member.php...o&userid=30730
> View this thread: http://www.excelforum.com/showthread...hreadid=503966
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks