Thanks for the reply!

I still can only get it to output for row 7 in cell AB7...does it have
anything to do with the statement:

Set KeyCells = Range("D7:AA7")

I have a feeling I need to change that to accomodate all rows, not just
row 7. Any ideas? Thanks again!