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??

I can't remember what I did.

Epinn

"Epinn" wrote in message ...
Yes, there is a limit to the number of characters (about 248?)

I put certain data/info in a cell. I can refer to the cell direct or use name definition.

InsertNameDefine

e.g. In cell A1 I type http://www.yahoo.com and define A1 as YH.

=Hyperlink(YH) or =Hyperlink(Sheet1!A1)

This saves quite a few characters. You can use multiple cells and concatenate using &.

See if this link helps.

http://exceltips.vitalnews.com/Pages..._in_Excel.html

If it is URL I can use TinyURL (www.TinyURL.com) to convert the lengthy URL to a much shortened version URL (a handle).

Then I hyperlink to the "tinyurl" - much less characters.

Haven't tried it with e-mail address. Same idea, I guess.

Hope this helps.

Epinn

"Dave Booker" wrote in message ...
The arguments for a HYPERLINK() worksheet function seem to be limited to 256
characters. Is there a workaround for this?

I need to embed functions like this
?subject=My Subject&body="&A1)
in a worksheet, and I need it to accept very long body arguments. If the
argument in this case gets much longer than 200 characters, the function
becomes a #VALUE.

Also, I can't use macros because of all the security issues the worksheet
users will encounter.