Hi,

I am trying to identify 2 errors within my macro.

due to the recent changes on the google Api platform, i think my program is broken and is causing 2 potential issues;

1. The formula is calculating the distance from a fixed location, regardless where the point of Origin is. EG - if the origin is " Sydney, CBD" , the reference points are  is in Brisbane, whereas the formula is originally meant to calculate the distance from Sydney to its surroundings.( which it used to do it previously, not anymore).

2. When the origin is entered as an address, it is not recognized or accepted. It has to be entered in co-ordinates. 

Would appreciate any help or guidence on this.