Hi guys,

I am wondering if i can use something like this:

For i = 9 To 200
    If Cells(i, 6) = Sheets("Machining").Range("j10") And Sheets(tab1).Cells(i, 12) = "As wound" Then Sheets(tab1).Cells(i + 1, 16) = (Sheets(tab1).Cells(i, 16) * (Sheets(tab1).Cells(i + 1, 14) - Sheets(tab1).Cells(i + 1, 18))) / (Sheets(tab1).Cells(i, 14) - Cells(i, 18))
    Next
Because for now it does not do anything but compiles...


Cheers