Autofill Dilemma

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

toby83 - 23 Jan 2006 10:55 GMT

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

Reply to this Message

Don Guillett - 23 Jan 2006 13:08 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>
> I would like to autofill 1,2,3,4,5 etc. in a column but I only want a
[quoted text clipped - 11 lines]
>
> Toby

Reply to this Message