Sorry, I should have done that in the first place. I whipped up a smaller version of the spreadsheet with fake names to protect privacy. I left the addresses blank, but kept the coordinates, which is how the formula calculates the distance. And in this particular workbook, the table it's grabbing data from is called Directory, instead of CRW. The name of the VBA module is GetDistance.


Thanks for helping me out!

Attached Files

Copy of CRW Addresses for Matt.xlsm (19.6 KB, 18 views)