Generate list of numbers between start and end value
Startvalue in A1, Endvalue in B1
Sub myFill()
[A1].AutoFill Destination:=Range("A1:A" & [B1] - [A1] + 1), Type:=xlFillSeries
End Sub
"Sinner" skrev:
Hi,
This should be simple.
I have a start value in one cell and end value in another.
I want to generate a list between them.
Start value: 8597000098881
End value: 8597000098890
Result:
8597000098881
8597000098882
8597000098883
8597000098884
8597000098885
8597000098886
8597000098887
8597000098888
8597000098889
8597000098890
Any idea?
|