On Wed, 1 Jul 2009 06:54:37 -0500, "Don Guillett"
wrote:

I haven't had a lot of time to play with this. Maybe you can send me a
sample wb. However, somewhere there must be a better way???

Better = fewer IE calls.

Since this was designed to be used in a Sub, one way to make it "better" would
be to purchase a zip code database (or DB subscription). But as used in a Sub,
it does make only one call per address line.

I think to be used as a "worksheet function", one would have to clearly define
the requirements in order to come up with fewer IE calls.
--ron