Formula for number sequence
I had earlier posted this on the Excel forum someone suggested I try the Excel Programming forum.
I’m trying to find a formula to create a sequence of numbers. The starting number would be in A1 and the ending number in B1. So if A1 = 88 and B1= 93 the result in the formula cell (C1) would be 88 89 90 91 92 93. I tried using =Row(Indirect(A1”;”&B1)) and I could get the correct results. When I record the process for a Macro (which is what I really need) it at first seems to work but when I change A1 or B1 to another range it does not work. When I look at the recorded code I am getting this.
Sub Macro1()
Range("C1").Select
ActiveCell.FormulaR1C1 = "88;89;90;91;92;93"
End Sub
I tried changing it this and got an error
Sub Macro1()
Range("C1").Select
ActiveCell.FormulaR1C1 = "ROW(INDIRECT(A1&":"&B1))"
End Sub
This was when I was thinking just a simple formula where there is a A1 +1 loop until the results equal B1 then break loop might be easier but it seems like this is way beyond my capabilities also and the formula is not so simple.
|