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?