View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pacheco pacheco is offline
external usenet poster
 
Posts: 2
Default 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?