Macro To Autofill Numbers Increasing

[sperryruss]

Hello,

I am using Excel 2000. I have only learned about using it somewhat in the last week. I have no knowledge of VBA programming except to open the VBA editor and copy into it.

I need to autofill a series of numbers that will increase, starting with a different number each time and ranging from column B to V (like entering 171 and having it go across autofilling ending up with number 191.

I have searched internet and this forum extensively and the closest thing I have found is:

Sub ExtendDates()

Selection.AutoFill Destination:=ActiveCell.Range("A1:V1"), Type:= _
xlFillDefault

End Sub

I am not dealing with dates just numbers but this is what this example had in it.

If I enter in a number in Column B this will copy it across to Column V. But I need it to increase one number in each column for 21 columns. I need a macro like this because I have to do this around 400 times.

Thanks.

[Charles]

Hi,

Welcome to the forum.

Try this

Please Login or Register  to view this content.

[sperryruss]

Thanks for your response Charles. That code says ExtendDate but I only want to Extend numbers. Even though it says date when I put in a number the first time and ran it, it worked. But it will not work again I restarted excel and repasted the code in the editor but it will not run.

The numbers I will enter will change like I might start at 171 one time and next time start at 1468 and needs to increasd no matter what number I put in and no matter what row I put it in.

Any more ideas?

Thanks

[Charles]

Hi,

Check the attachment.

[sperryruss]

Charles,

That is just what I needed. Thank you very much for going into all the detail and putting it on the Excel sheet. It works like I need it to.

I only started learning Excel in the last week to help a business friend of mine who does not know very much about computers. I have learned a lot about different programs and computers during the last years but never had a need for Excel. This experience has shown me that it may come in handy for a lot of things in the future.

Sperry

[Ravi99522]

Hiii,
I need a macro through which i can auto fill a column by 1,2,3.....(in increasing order) till the last row with reference to data in next column. For this i am attaching a excel sheet in which i need to auto-fill the first column w.r.t till the data fill in 2nd column.



Thanx

[Charles]

Ravi99522,

Welcome to the forum.
However, you need to start your own thread.

[Ravi99522]

Hi Charles,

How to start a new thread ???

[Charles]

Look at the Left side of the Question page near the bottom you will see "Start New Thread".