Help!

[mckenshie]

I am trying to figure out how to continuously do a function starting from x = 0 to x = 20 with an increment change of 0.1. I want to use vba to list all the values that resulted to a sign change in an array but I have no clue on where to start. Please help.

 

[maabadi]

Welcome to MrExcel Message Board. This is example:

Sub multiply()
Dim i As Long, Arr(0 To 200) As Variant
For i = 0 To 200
Arr(i) = (i * 0.1) * Range("A1").Value
Next i
Range("B1").Resize(201).Value = Application.WorksheetFunction.Transpose(Arr)
End Sub

1. You can replace Range("A1").Value with your formula
2. Last line only added to you see array result within excel sheet. If you don't need, delete it.

 

[EXCEL MAX]

Wellome,
here is one more...

Sub For0To20()
   
    Dim x As Integer, N As Integer, Result
   
    N = 10
    For x = 0 To 20 * N
        Result = x / 10 + N / 100
        Range("A" & x + 1) = Result
    Next x
   
End Sub

 

[Fluff]

Another option

Sub mckenshie()
   Dim Ary As Variant
   
   Ary = Evaluate("row(10:200)/10")
End Sub