For Each yy In Worksheets(ws).Range(Cells(8, 1), Cells(8, 160))
If yy.Value = “Stop” Then
jj = yy.Column
Why would you use yy ? (nervous twitch??) (or jj)
Also note how I have generously indented it for your delight, unlike the original.