Loop single row to get result based on if function

Vote count:

0

i want your help here, as i am trying to do if function for each cell in one row using loop with function. to explain myself more, here what i want to do A b C D E 1 al sl al HD al

2

i have the above excel cells in which i want to say in my code in cell "A2"

Dim cng As Range Dim rng As Range

Set rng = Range("A1:E1")

For Each cng In rng If Cells(1, 1) = "al" Then Cells(2,1) = 8 Else Cells(2, 1) = 0 End If Next cng end sub

here i want the code to do the same for B2, C2, D2 and E2 as well. thank you very much in advance for your help

asked 21 secs ago

Nabil Amer

1

Loop single row to get result based on if function