The Cellar - View Single Post

BigV · 05-26-2006, 02:17 PM

mbpark:

Thank you! That is very very promising, but my VBA skills are weak. I followed the directions, and I get an interactive display of the result, but the cell does not contain/display the result, by which I mean the linklocation. The link location does show up in the interactive gadget created by the user defined function, but I don't know how to get that substring out and into a cell somewhere.

The =GetAddress function performs the getting of the address, but only while the function is running. I'm looking for some way for the function to *evaluate* to the linklocation.

05-26-2006, 02:17 PM	#10
BigV Goon Squad Leader Join Date: Nov 2004 Location: Seattle Posts: 27,063	mbpark: Thank you! That is very very promising, but my VBA skills are weak. I followed the directions, and I get an interactive display of the result, but the cell does not contain/display the result, by which I mean the linklocation. The link location does show up in the interactive gadget created by the user defined function, but I don't know how to get that substring out and into a cell somewhere. The =GetAddress function performs the getting of the address, but only while the function is running. I'm looking for some way for the function to evaluate to the linklocation. __________________ Be Just and Fear Not.