How would I insert a value to a Cell with the row number of 'I'?

[kbj0109]

I found a row number with Loop using i,

If I want to insert a value of Total Sales.
How would I write the code to choose the Cell or Range with the raw number i?


This is my current code, but not working.

TotalSales = Qty*Price
Cells("i", "a") = TotalSales.Value

If I put a specific number instead of i there, it works. but with i, It's not.
Anyone can solve the problem?

 

[SteveO59L]

try posting a sample of your data, and what you want to achieve

 

[kbj0109]

I just want to know how to use 'I' as a Raw Number when we choose a Cell.

It has to be with ' I '...

 

[Big Wade]

Cells( i, "a") = TotalSales.Value

 

[kevatarvind]

see below code

Sub Test()
For i = 1 To 10
    Cells(i, 2).Value = Cells(i, 1).Value  ' it will copy column A value to column B till row 10
Next
End Sub