Hi there,
Can any help with this?
What I need is to check each value of row ai, column 70 and if the value is greater then forty i paste a value in row ai, column 78. If not no action.
Shoud be simple but doesn't work.
Sub fCheck_BP_BQ()
Dim cBR As Integer
finalrow9 = Cells(65536, 57).End(xlUp).Row
For ai = 2 To finalrow9
cBR = Cells(ai, 70).Value
If cBR > 40 Then Cells(ai, 78).Value = "No information in DCR path"
Next ai
End Sub
I have existing data and I need to set cBR to scroll from bottom up through each loop as the existing data in cell (row ai, column 70).
I tried to just type:-
if cells(ai,70).value > 40 then Cells(ai, 78).Value = "No information in DCR path"
but that errored as well.
Any ideas, Please help. Thanks
Please help I am stumped, but it should be so simple.
Can any help with this?
What I need is to check each value of row ai, column 70 and if the value is greater then forty i paste a value in row ai, column 78. If not no action.
Shoud be simple but doesn't work.
Sub fCheck_BP_BQ()
Dim cBR As Integer
finalrow9 = Cells(65536, 57).End(xlUp).Row
For ai = 2 To finalrow9
cBR = Cells(ai, 70).Value
If cBR > 40 Then Cells(ai, 78).Value = "No information in DCR path"
Next ai
End Sub
I have existing data and I need to set cBR to scroll from bottom up through each loop as the existing data in cell (row ai, column 70).
I tried to just type:-
if cells(ai,70).value > 40 then Cells(ai, 78).Value = "No information in DCR path"
but that errored as well.
Any ideas, Please help. Thanks
Please help I am stumped, but it should be so simple.