You can use the same method to open directly in google Earth

=HYPERLINK("http://www.google.com/maps?f=q&hl=en&output=kml&q=" & A2 & ",+" & B2,"Google Earth")

The Google Maps site has a nice feature to output KML which will open the search directly in Google Earth
_________________________


- www.nearby.org.uk - www.geograph.org.uk - www.trigtools.co.uk -