From what I understand, there needs to be an On Error of sorts, because
you're going to be testing for c.Address, and if c Is Nothing, then it
doesn't have an address property. I believe that is the error you are
receiving. Um, did I miss something again? Or is that what you are talking
about? (Wouldn't be the first time ... )

--
Regards,
Zack Barresse, aka firefytr


"Wild Bill" wrote in message
...
On Fri, 29 Apr 2005 20:33:34 -0700, "Zack Barresse"
wrote:
There would be no need to test for it inside of the loop.
(...)
So both checks, for Is Nothing and if the .Address < FirstAddress
(barring
it's been set), are necessary for a complete check and to cover all your
bases.

But what we're seeing is that the code bombs when c really is Nothing.

It's similar to this deal:
A1=NA()
B1=IF(OR(ISNA(A1),A1=0),1,0)

You'd like it to give 1, but it gives #N/A