Hi! Thanks for reading!
I have a function that search a list of objects from a database and list them in the active worksheet.
I would like to add a function that links each object to its position in the database. This position has to be found every time with a search function. So the SubAddress of my Hyperlink function should be a function.
How can I do that?
For example I have:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=""
Where the SubAddress is a function called "search". I tried but i couldn't find the way to insert a function inside the Hyperlink function. How can I do that?
If this is not possible, how can I write a personalized Hyperlink function?
Hope someone could help me somehow!!!
Thank you very much,
Ciao from Modena, ITALY
Bookmarks