Hey guys, I'm looking to put a few if/elseif conditions within a for each loop. Is this possible/ any suggestions as to how I can get it to work?
Sub rating()
Thanks for the help!![]()
Dim terr As Integer For Each mycell In Sheets("Orig File").Range("p8:p999999") If mycell.Value = "a" Then mycell.Value = 1 ElseIf mycell.Value = "b" Then mycell.Value = 2 Next mycell End sub
Bookmarks