Currently my UDF WName()outputs a result in each spreadsheet cell that it was called from.
Now I am focused on developing the last few lines in order to output a second variable ("MinDist") four cells to the right of each UDF call in the spreadsheet.
I'm trying to do this via ActiveCell.Offset., but not getting the result I need. Here's a snipit:
Full spreadsheet and VBA code attached.
Please Login or Register to view this content.
Note that for debugging, I'm just looking now at sheet "A", cell "A14"