search

maxrice / excel-geocoding-tool

Easy to use Geocoding tool for Excel.
82 stars 30 forks source link

Excel 2010 - geocode sample data present (selected row) = Run-time error '9' #15

Closed bhath closed 11 years ago

bhath commented 11 years ago

I loaded the excel spreadsheet. Macros are enabled (the test button on the first sheet works). I created a new Bing Maps Key and put it in the appropriate cell on the first sheet. attempting to geocode the sample data (first row only), I get the following error: Run-time error '9': Subscript out of range.

going to Debug, it pops up at this line in the code (it's line 121): If resultarray(0) = "" Then resultarray(0) = "not found"

Any ideas?

Best, Brad

jglide commented 11 years ago

Just wanted to second this. This occurs every time it comes across an address with a suite number or PO box (Suite #, Ste, Suite, PO, #, 123A, etc). I have come to expect this but it is also occurring with some addresses that look normal.

I noticed the 'Continue' button is grayed out. It would be nice simply to have the opportunity to move on from these without having to select another set of rows.

This being said, this tool has already made my task exponentially simpler and is much appreciated!!! Thanks, Jared

vishnyakova commented 11 years ago

I am having this problem too.

tcm-nm commented 11 years ago

I am also having this problem. Does anyone manage this project anymore?