Help populating cells from vba script.

[wzz]

Hi,

I was trying to "convert" this matlab *.m file that I have to excel vba but just don't have enough knowledge to do so in regard.

What i'm trying to do here is to plot a value of x against time.

Please Login or Register  to view this content.

vba attempt:

Please Login or Register  to view this content.

And then when the cells are populated by the values of x I would plot them against, say b1:b78, which would be time t+t, to get my graph.

ANY help would be appreciated.

Thanks.

[mewingkitty]

For i = 2 To 78
x(i + 1) = (a * x(i - 1) - (b / (t * t)) * x(i - 1) + x(i) + t * x(i)) / (b / (t * t) + c / t)
Next i
Cells(1, 1).Value = x()

What this is doing, is calculating this value for i 2 to 78, then placing the value in cell 1 1 after it's all over.
Try this

For i = 2 To 78
x(i + 1) = (a * x(i - 1) - (b / (t * t)) * x(i - 1) + x(i) + t * x(i)) / (b / (t * t) + c / t)
cells( i, 1).value = x
Next i

I't adding in a line which increases the row referenced which has the value entered as i increases from 2 to 78.