Hi PraetorianPrefect, Bob

The code will handle up to 65535 entries, ie a whole worksheet. It
handles 40,000 addresses or so for my company.

The 2000 reference in the code is a message for the code to dump the
variant array in 2000 record chunks.

As Bob suggested you can filter the records by location

Cheers

Dave


--
brettdj
------------------------------------------------------------------------
brettdj's Profile: http://www.excelforum.com/member.php...fo&userid=3903
View this thread: http://www.excelforum.com/showthread...hreadid=376364