Bruce,
Not sure if it works for HyperLinks, but to get around the limit for
..FormulaArray, you can insert some of you string, with a #place holder#. The
replace the #place holder# with the remainder of the text.

NickHK

"Bruce" wrote in message
...
I'm trying to add some rather lengthy hyperlinks, and I'm coming across an
apparent length restriction. The URLs I'm trying to add often include some
query-looking stuff that looks like ASP (I'm not familiar with ASP). For
example,
"http://www.someplace.com/AllItems.aspx?RootFolder=%2fblahblahblah...". It
looks like the address gets truncated after 256 characters. I've tried the
HYPERLINK() function, the InsertHyperlink menu item, as well as adding
hyperlinks with VBA, but I get the same result. Am I missing something, or
am
I just out of luck?

Is there another way (using VBA perhaps) to maybe feed the url addresses
to
some system command, for example, launch IE and provide the url address?

Thanks for any responses.

--
Bruce J. Baumann