Well - the snippit is great - I was unaware of how to write a time event -
Love to learn new things - BU But still no luck with the If c.address
statement. I even removed the little portion of the code and tried it on a
blank worksheet without success. Is it possible 'Address' is not stored in my
library correctly? Anyway - I think I will take a fresh look at this
tommorrow. I sure appreciate all your suggestions.

Carrie

JLGWhiz wrote:
It could be that you need a brief delay just after that statement to give the
Exit For
time to work. Try inserting this snippet in just after the if statement:

s = Timer + 0.5
Do While Timer < s
DoEvents
Loop

That will give it a half second delay. If it still don't exit, I have no
other guesses.

Thanks and you are right I forgot to change the range back to AU65535.
However it still did not solve my problem. The statement does not recognize
[quoted text clipped - 17 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200801/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200802/1