trying to find a way to show a closest to using lat and long coordinates

		Microsoft Office Forums > Microsoft Excel > Excel
trying to find a way to show a closest to using lat and long coordinates

FAQ

Thread Tools

Display Modes

#23

05-17-2025, 03:22 PM

macropod

Windows 10 trying to find a way to show a closest to using lat and long coordinates

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,465

Quote:

Originally Posted by cwgitahi

Hello, the code also doesn't seem to be working for my data set.

It doesn't work for the simple reason you have dozens of cells with #N/A in columns A & B of your ATC sheet. Works just fine if you delete the #N/A entries or, better still, correct them or delete their rows.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

find the closest, lat and long

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show two alternating slides as long as music plays	Magic	PowerPoint	2	11-23-2014 09:02 AM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
Highlight and put bookmark on the closest field to the cursor	b0x4it	Word VBA	11	05-19-2011 11:15 PM
Question: Hyperlink to other show, but close the current show	habibfikri	PowerPoint	0	12-26-2010 02:37 AM
PP 2010 .avi file plays during slide show, but causes the slide show to loop to begin	VictorS	PowerPoint	0	10-16-2010 10:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 PM.