I missed this additional question because you edited it 2+ hours after you first placed it and I got notified of a new post before that; so when I checked it there was no additional question!
Anyway, more than 3 weeks later, try:Intersect(.ResultRange.EntireRow, .Parent.Range("Q:Q")).SpecialCells(xlCellTypeBlanks).Value = "x"