Thanks jindon, that is enlightening. And answers a few questions for me. But I still have my original question 
DXNRY(CStr(Range("F" & z))) = 1
What does the "= 1" do? I realize it sets its value to one but what does that let you do? Does it need to be there? Does it matter even what that is set to? Could I have it set to 
DXNRY(CStr(Range("F" & z))) = Whydoesthisneedtobehere??
Thanks in advance