VBA Google Maps to return the URL of the final Loaded Page

[dazz149]

Hi,

Can anyone please help? I have the following code and I am looking to Google Maps to return the url of the final page. At present it is only returning the intitial load up url.

Below is my simple code so far,

Sub GotoAddress()


Dim IE As New InternetExplorer
IE.Visible = True
IE.navigate Sheet1.Range("B2").Value
Do
DoEvents
Loop Until IE.readyState = 4


Sheet1.Range("B22").Value = IE.LocationURL




End Sub


Any Help in this matter would be greatful.