After doing some poking around, I wrote this code that is supposed to insert a formula in Column L of the current row that pulls some information from column GI of the same row. Here's what I have:
The objective is a formula in column L of the current row that inserts a hyperlink that points to the same cell, with Add Opt being displayed.
It doesn't work.
VBA Code:
Sub InsertFormula()
Sheets("Calendar").Range("L" & ActiveCell.Row).Formula = "=HYPERLINK(""#L" & "Sheets("Calendar").Range("GI" & ActiveCell.Row).Value"", ""Add Opt"")"
End SubThe objective is a formula in column L of the current row that inserts a hyperlink that points to the same cell, with Add Opt being displayed.
It doesn't work.
Last edited:
