Try making the radii bigger (40). At that point, you should be able to click on them and "Export to Excel." This will cause all four pushpins to show up in the exported file since the circle encloses all of them.

Basically, what I want to do is use the import wizard to put data by zip code on the map (which I can do), add a bunch of radii (which the program does), and export the radii to determine which zip codes are included within them. The question is how to export the radii using VBA so that I don't have to manually click on hundreds of them and export.

Thanks.