I figured out what was wrong. Instead of saying ActiveCell.Formula and
ActiveCell.Value, I should be using Cell.Formula and Cell.Value. I
guess when you're in a For Each...Next loop, ActiveCell never changes,
but you have to reference what cell it's on in the range by using just
the word "Cell".

Thanks Tom for giving me some guidance here.