select cell in a column matching text value of another cell

[mdd16]

Hello,

I have a small code that's going into an endless loop... help to resolve will be highly appreciated .. screen shot of excel attached.

Sub Fill_Xirr()

ActiveSheet.Range("IrrTab_Beg").Offset(1, 1).Select

Do While Not IsEmpty(ActiveCell) _
    Or Selection.Value <> Range("myTicker").Value
        Selection.Offset(1, 0).Select
Loop

F = Range("YrsInvested").Value
Selection.Offset(0, F).Value = Range("X_IRR").Value

End Sub

 

[6StringJazzer]

Change Or to And.

Your logic is wrong. Your loop will continue any time either of these conditions is True

Not IsEmpty(ActiveCell) Or Selection.Value <> Range("myTicker").Value

But one of these is guaranteed to be True for every cell. So it just keeps going.

 

[mdd16]

resolved... thanks so much