Loop seems to be repeating net result instead of running code.

[m0meehan]

I have a simple but long code containing multiple and independent if then statements to perform on a cell. I then want all those if then statements to be repeated on every cell in the column until reaching an empty cell. It seems the Do Until Loop would do the trick, but instead of repeating multiple if then statements and coming to individual conclusions for each remaining cell, it's only applying the net effect of cell 1 on every single cell in the rest of the column. Restating the issue using the example code and attached workbook, I'd like the code to apply all 3 if then statements on all cells in column D. Instead it is correctly evaluating cell D2 but then ignoring the if thens for the rest of the cells by just applying the same net result it found for cell D2. Any thoughts?

Please Login or Register  to view this content.

[protonLeah]

celltxt = ActiveCell.Text
is outside of the loop and never changes...

[m0meehan]

beautiful. thanks!