how do i use the R[]C[] notation in visual basic, for example to .

[pacheco]

Trying to write a macro... want certain value to be assigned to cells on
different rows according to a counter, so would be useful to use the R[]C[]
notation to assign a value to a cell.
I can use for example
cell("D3").value = 5
But how would I write something like
cell(R[3]C[4]).value = 5
The compiler rejects the example above... what is the right way of using the
Row/Column notation in Visual Basic for Excel?

 

[Debra Dalgleish]

You can use the Cells property:

Cells(3, 4).Value = 10

Trying to write a macro... want certain value to be assigned to cells on
different rows according to a counter, so would be useful to use the R[]C[]
notation to assign a value to a cell.
I can use for example
cell("D3").value = 5
But how would I write something like
cell(R[3]C[4]).value = 5
The compiler rejects the example above... what is the right way of using the
Row/Column notation in Visual Basic for Excel?