Storing values as array/matrix in VBA loop

[joejackson123]

Hi all, I have the following code

Sub sensitivity()
Dim a1, a2 As DoubleDim i As StringDim offerarray() As VariantDim arraycount As Long
a1 = Range("low").Valuea2 = Range("hi").Value

For i = a1 To a2 Step 0.001
Range("disc").Value = a1 + i
offerarray(i) = Range("propoffer").Value
Next i
End Sub

propoffer, disc low, and hi are all named cells within my spreadsheet. I can't figure out how to store the value from "propoffer" in each step of the loop in an array (which I then later want to post to another sheet). Any help is much appreciated, thank you!

 

[Dim Me as xlNoob]

Glad to hear you got it sorted. So you have a full solution now?