Hi there
I want the code below, which is in a macro in the attached workbook, to create a hyperlink in the selected cell. The destination address should be created from the value in the cell, which is to a cell in another worksheet in the same workbook. The text to display should be “--->Sheet2”.
The code does create a hyperlink with the correct address, but the “text to display” is the cell value instead of “--->Sheet2”. Would someone please help me to get the “text to display” working as intended.Please Login or Register to view this content.
Thanks,
Stu
Bookmarks