search

nuket / google-sheets-geocoding-macro

Geocode from addresses to latitude / longitude, and vice versa using Google Sheets
334 stars 148 forks source link

Map Cells in Mapping image throws error #14

Closed TacticalPants closed 3 years ago

TacticalPants commented 3 years ago

Hi,

I'm attempting to run the 'Map cells in mapping sheet' function from the menu and I am flagged with this error 'TypeError: Cannot read property 'getRange' of null'. I initiate the function by highlighting three cells, the first two of which are the Lat and Long coordinates, then clicking the function in the menu. How can I resolve this error?

nuket commented 3 years ago

If you do this in the Mapping tab, it should work. It does not work in the Test Addresses or Reverse To Components tabs. On April 8, 2021 13:44:30 TacticalPants @.***> wrote:

Hi,

I'm attempting to run the 'Map cells in mapping sheet' function from the menu and I am flagged with this error 'TypeError: Cannot read property 'getRange' of null'. I initiate the function by highlighting three cells, the first two of which are the Lat and Long coordinates, then clicking the function in the menu. How can I resolve this error?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

nuket commented 3 years ago

Explainer: https://github.com/nuket/google-sheets-geocoding-macro#map-cells