HYPERLINK in a Function using for example "mrexcel.com/forum/" & string" How to apply it in a function?

[makiwara]

Hi!

So I have something like this:

Function InsertHyperlink (x as string) as string


InsertHyperlink = "=HYPERLINK(""www.mrexcel.com/forum/" & x")"

end Function

Since it's totally wrong, any idea? Have a nice day!

 

[Saba Sabaratnam]

I am not sure about your requirement. I assume that you tried to create a new function to add a text to a hyperlink. Instead of it, you can use the following function.

=HYPERLINK("www.mrexcel.com/forum/"&"x")

Kind regards

Saba

 

[makiwara]

Thank you!

But unfortunately, although the result is a clickable link, it shows an error message every time I try to click on it.

"The address is invalid" or something similar.

Case 1:
www.google.hu/gmail WORKS FINE WHEN I TYPE IT
Case 2:
=HYPERLINK("www.google.hu/" & "gmail") it's clickable too, but shows the invalid error message every time i click.

Any idea? And if we could use VBA to solve it that would be great because the best scenario would be for me a VBA function, which generates HYPERLINKS using a cell's value (which is "x" in my function)

Thank you for your answer! It means to me a lot! Have a nice day!

I am not sure about your requirement. I assume that you tried to create a new function to add a text to a hyperlink. Instead of it, you can use the following function.

=HYPERLINK("www.mrexcel.com/forum/"&"x")

Kind regards

Saba