Dave,

Any luck? I would appreciate it if you could post back the solution i.e. if there is one.

I did more research. The limit is about 255/256 which is the column width. But a cell can hold over 1,000.

We both know that =hyperlink(A1&A2) works when the sum of the characters is below the limit. It will return #VALUE if over.

To my surprise =hyperlink(A1)&hyperlink(A2) also works when below the limit. I don't have a long URL to test for the over limit condition. I put 254 characters in A1 and (also 254 characters in) A2 respectively. The formula does not return #VALUE error. It displays blue fonts and the underline i.e. the hyperlink format. I am not hopeful that this actually works. But I just want to let you know. May be you can think of something else.

Looks like FollowHyperlink method is one way but I know that's not something you want.

Epinn

"Dave Booker" wrote in message ...
Yes, even if we're using cell references, as soon as the length of the values
of the references exceeds the magic limit -- 248 or whatever it is -- the
function itself fails.

"Epinn" wrote:

Sorry, I missed that you were using a cell already.

There may still be a problem using concatenation of multiple cells if the characters added up to over 248??