should I be using a loop

[jdoiron]

I want to perform a calculation in a column, I want the product of the previous 2 columns divided by 100 and I want this column to be populated until there is no data in the previous 2 columns.

I have created a do loop but it just performs the calculation in the first cell and does not move down the column.

Any suggestions would be appreciated.

thank-you

 

[Andrew Poulsom]

Like this?

Sub Test()
    Dim Rng As Range
    Dim c As Range
'   *** Change column and starting row reference to suit ***
    Set Rng = Range("C1:C" & Range("A65536").End(xlUp).Row)
    For Each c In Rng
        c.Value = (c.Offset(0, -2).Value * c.Offset(0, -1).Value) / 100
    Next c
End Sub