View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Booker Dave Booker is offline
external usenet poster
 
Posts: 8
Default Workaround for HYPERLINK argument length limit

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