hyperlink

[mdavison69]

i am trying to create a hyperlink that is very long - the idea is that i am passing variables to a webpage... but i think i am running into a limit on the amount of characters that are allowed when just using the HYPERLINK() function. Is there a vba script that can get around this limitation?

[p45cal]

That depends.. how long is very long?
You could explore the likes of:
strURL = "http://www.google.com/"
ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:=strURL, TextToDisplay:="Google"or there is the .followhyperlink method.

[mdavison69]

Thanks, i'll give it a try!