Making the worksheet.hyperlinks.add method work!
Alternatively, another solution I tried was to insert text to the cell that
is of the form:
range.values = "=HYPERLINKS(\"" + address + "\", \"" + text + "\")';
This sorta work... when the worksheet opens, though, the literal string is
displayed in the cell, and only if I select the cell, then select somewhere
in the string in the text bar up top, then click somewhere else in the
worksheet, only then does the text display correctly as hyperlinked.
Any clues on making it display correctly from the get go?
TIA!
|