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?
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?