Hi,
I am getting a Run-Time error message when I run this code.
Can someone fix it?Private Sub CommandButton1_Click()
FinalRow = Cells(Rows.Count, 1).End(x1Up).Row
For I = 2 To FinalRow
If Cells(I, 6).Value > 0 Then
Cells(I, 7).Value = "Profit"
End If
Next I
End Sub
Thanks,
Nix