First macro.....................

Sub Fill_Nums()
With Range("A1")
.FormulaR1C1 = "1"
.Select
Selection.AutoFill Destination:=Range("A1:A65536"), _
Type:=xlFillSeries
End With
End Sub

Cannot provide a macro for second scenario.

I do not understand the sequence.


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 11:41:05 -0800, Paul Tikken
wrote:

I'm using excel 2003

I would like to create a macro that is creating a number sequence (from 0 to
77777) only using the numbers 0 tru 7. So when I select a cel say A1 and I
run the macro the first column needs to be filled with:
1, 2, 3, 4, 5, 6, 7, 10, 11, 12, 13, 14, 15, 16, 17, 20 etc etc etc.

An other macro I would like to create is one that provides me with the
following number sequence (lets say in column C)

0, 77, 100, 177, 200, 277, 300, 377, 400, 477, 500, 577 etc etc etc

Can anybody help me with this?

Regards,

Paul