Am confused for this class am taking we had to design serval procedures that do different things: 6 procedures were sine, cosine, cube, square, common log, and natural log. In order to get this values we had to design loops. I have done that but, our professor wants us to have output values of x into column A (on excel worksheet), starting at row 2, and the corresponding values of f(x) into column B. This can be done by using the same loop used to evaluate f(x).

Question

example:
For i = 1 To n
funct(i) = Sin(values(i))
Next i
Please help :)

Answer 1

The ActiveWorksheet has an array called Cells. So, if you say

Cells(i,1) = values(i)
Cells(i,2) = funct(i)

then the columns will get filled in as you loop