joejackson123
New Member
- Joined
- Oct 27, 2017
- Messages
- 16
Hi all, I have the following code
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!
HTML:
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!