Excel visual basic

[Guest]

I want to write a macro that will write values to cells on a sequence given
by a counter. For example counter = 1 then writes a certain value to cell A1,
then if counter goes to 2, i want the result to be posted on cell A2 and so
on so forth, so when this macro is run, it will do some calculations and post
for example 20 results in 20 rows on the same column. Could be easy to do
using the R[]C[] notation but I dont know how to do that... can anyone help?

 

[Frank Kabel]

Hi
cells(counter,1).value="certain value"

--
Regards
Frank Kabel
Frankfurt, Germany

I want to write a macro that will write values to cells on a sequence given
by a counter. For example counter = 1 then writes a certain value to cell A1,
then if counter goes to 2, i want the result to be posted on cell A2 and so
on so forth, so when this macro is run, it will do some calculations and post
for example 20 results in 20 rows on the same column. Could be easy to do
using the R[]C[] notation but I dont know how to do that... can

anyone help?