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.