Hi all,
I'm having trouble with a hyperlink formula.
When I use the below the formula shows as
As an example, the formula bar for AA5 would show
I tried adding .Value, but that didn't change the output.
Thank you
I'm having trouble with a hyperlink formula.
When I use the below the formula shows as
=HYPERLINK("https://webaddress.com/?query=" & G5,G5)
, but what I need is the value in G5 to show in the formula and not the cell reference.
VBA Code:
ActiveSheet.Range("AA5") = "=HYPERLINK(""https://webaddress.com/?query="" & G5,G5)"
As an example, the formula bar for AA5 would show
=HYPERLINK("https://webaddress.com/?query=" & 525252,525252)
, if the value in [G5] was 525252.I tried adding .Value, but that didn't change the output.
Thank you