Proper syntax to exit a loop if IsError is true

I don't know why your IsError system isn't working...everything I look up shows that it uses a IsError(RtnValue) and the RtnValue is set from an expression (IE: a valid error number), so in theory it should work...but I wouldn't use this looping technique for this application....I believe both stnkynts and I have shown a different and possibly better way...I totally understand your wanting to understand why this doesn't work and I can only give a weak answer....sorry....HTH

Edit: the IsError didn't show in the actually looping construct....not that it can't, I just haven't seen it used that way....