If Cells(i, 6) = Sheets("Machining").Range("j10") And Sheets(tab1).Cells(i, 12) = "As wound" Then
Let myrange = "f" & i + 1 & ":" & "f" & i + gr
For Each cell In Range(myrange)
cell.Value = Sheets("Machining").Range("J10") & "." & Chr(56 + i)
i = i + 1
Next cell
End If
Bookmarks