Excel visual basic
 

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?

Excel visual basic
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"pacheco" schrieb im Newsbeitrag
...
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?