I am using mappoint 2006 on excel vba and I am able to calculate distance between two zipcodes by adding vba codes to exccel but what I am not able to do is to find "city and state" on given zipcodes. Basically I want to be able by entering zipcodes into excel cells, "city and state" affliated with that zipcodes shows up into anther cell just like "distance" doses. Anybody knows the codes for this?