Hi Dave,
Thanks for getting back to me. I'm really stuck on this.
You're right... the ArgString has no value which is causing the error (I used your trick to place MsgBox Argstring before the error). I wrote an If Statement to bypass the error, but the problem is that I need the value to work and I'm not sure why it's coming back as nothing. The code brings back address values for every other one but this cell and I have no idea why....I'm racking my brain on this one.

Can you help?
Jim