Thread: GetDistance Formula
View Single Post
 
Old 02-12-2020, 03:08 AM
mandersen04 mandersen04 is offline Windows 10 Office 2016
Novice
  
Join Date: Sep 2018
Posts: 12
mandersen04 is on a distinguished road
Default
Wow, I didn’t even think of that. Thanks for the suggestion! It works fine now.



Quote:
Originally Posted by p45cal View Post
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…
Reply With Quote