Thanks for taking the time to respond here. I was messing with that approach for hours last night but I don’t have a very good understanding of how arrays work. When I ran that my results were ={88;89;90;91;92;93}. When I record the process for a Macro 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"
Range("D2").Select
End Sub
I tried changing it this and got an error
Sub Macro1()
Range("C1").Select
ActiveCell.FormulaR1C1 = "ROW(INDIRECT(A1&":"&B1))"
Range("D2").Select
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.
|