Looping through a Range of Data

[paulked]

Hi and welcome to the forum.

This is one of many ways:

Sub Ked()
    Dim x As Long
    For x = 5 To 7 ' E-G Column numbers
        If Cells(1, x) = "Task A" Then Call CODE_ABC(Cells(11, x)) 'Only call sub if condition met
    Next
End Sub