The only issue I had was that Googles API doesn't like it if too many requests are made too quickly so I created a function to add the geocoding calculation into a column one cell at a time and waiting one second between calls.
Below is the function
Sub Geocoding100()I can leave this function running in the background to geocode a list of addresses in excel and I am not hammering Google Geocoding API.
For I = 1 To 100
ActiveCell.FormulaR1C1 = "=GoogleGeocode(RC[-1])"
Application.Wait (Now + TimeValue("00:00:01"))
Its a win win situation!