Assigning Hyperlink to Cell via Macro

[lx1991]

Hello Guys,
I’m trying to build a Macro that should write a URL link to a specific cell. After combining the URL and posting it into the cell with

oFormulaURL = "=HYPERLINK("""& oStringURL &""", ""click me"")"
outputCellURL.setFormula(oFormulaURL)

I am greeted with an Err:508 in the spreadsheet. However, making any single change in the input line for that cell and immediately reversing it fixes the error and I get a clickable link. Any idea what I’m missing here?

Also, on a less important note - is it possible to make the links from the HYPERLINK() function blue like the ones created using the Ctrl+K popup?

Cheers

[Villeroy]

The list separator in formulas is always the semicolon, no matter what may be shown in the user interface.

[lx1991]

Thanks, that fixed it.

[Steph1]

@lx1991

Also, on a less important note - is it possible to make the links from the HYPERLINK() function blue like the ones created using the Ctrl+K popup?

You can add the line:

outputCellURL.cellstyle = "Hyperlink"