LOOP.letter appears in one column if condition met in other column.

[barrowinfurnace]

Hello all,
I have a spreadsheet consiting of twelve columns of data.(Columns A to L) The number of rows varies:
Column H is populated with numbers.
I would like to loop through and when the number 44 appears in column H, I would like to place the letter Y in the NEXT ROW DOWN in Column M

So lets say in row 12 the number 44 appears in Col H,then the letter Y will in the next row down in Col 13(M).
Any help appreciated
Kind Regards
BIF

[Marc L]

Why not just using a formula ?!

Anyway an Excel basics VBA demonstration as a beginner starter :

Sub Demo1()
        Dim Rf As Range, R&
    With ActiveSheet.UsedRange.Columns(8)
        Set Rf = .Find(44, , xlValues, 1)
     If Not Rf Is Nothing Then
        R = Rf.Row
     Do
            Rf(2, 6) = "Y"
        Set Rf = .FindNext(Rf)
     Loop Until Rf.Row = R
        Set Rf = Nothing
     End If
    End With
End Sub 

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[Sintek]

Please Login or Register  to view this content.

[barrowinfurnace]

Thanks to both Mark L and sintek for both solving the problem with different coding.Both examples worked perfectly.
much appreciated and kind regards
bif

[Sintek]

..............................
THANKS.gif