Has anyone experienced the restriction within Excel (2007), when using the HYPERLINK function on URLs longer than 255 characters. I assume this is some built-in restriction (similar to SQL varchars), but am wondering if there is any work around. FYI, we are using high quantities of data, so URL shortening sites such as bit.ly, wouldn't be adequate for the task at hand.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
255 character limit in HYPERLINK function
- Thread starter pricer
- Start date
tweedle
Well-known Member
- Joined
- Aug 1, 2010
- Messages
- 1,559
No, not really.
From Help:
A variable-length string can contain up to approximately 2 billion (2^31) characters.
A fixed-length string can contain 1 to approximately 64K (2^16) characters.
Code:
Sub foo()
urladd = "[URL]http://thelongestlistofthelongeststuffatthelongestdomainnameatlonglast.com/wearejustdoingthistobestupidnowsincethiscangoonforeverandeverandeverbutitstilllookskindaneatinthebrowsereventhoughitsabigwasteoftimeandenergyandhasnorealpointbutwehadtodoitanyways.html[/URL]"
Sheets(1).Hyperlinks.Add Range("B2"), urladd, "", "URL Len: " & Len(urladd), "A Long URL"
End SubFrom Help:
A variable-length string can contain up to approximately 2 billion (2^31) characters.
A fixed-length string can contain 1 to approximately 64K (2^16) characters.
Last edited:
Upvote
0
Similar threads
- Question
