GetDistance Formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
GetDistance Formula

FAQ

Thread Tools

Display Modes

02-12-2020, 03:08 AM

mandersen04 mandersen04 is offline

Windows 10 GetDistance Formula

Office 2016

Novice

Join Date: Sep 2018

Posts: 12

Wow, I didn’t even think of that. Thanks for the suggestion! It works fine now.

Quote:

Originally Posted by p45cal

Ha ha ha!
Change the name of the module from GetDistance to anything that's not the same as the name of a function!
You might have to do something similar with the other module.

You could instead change the formulae to the likes of:
=GetDistance.GetDistance(VLOOKUP(B$1,Dir…

Tags

#name?, getdistance

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Copy Row 2 Row But Next Column In Formula From Another Tab	TimG	Excel	3	04-16-2018 09:20 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula	Excel	Excel	1	08-14-2014 05:11 PM
help with formula?	doczilla	Excel	2	09-25-2011 04:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 AM.