View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad B.
 
Posts: n/a
Default How can I change 255 character limit in 'hyperlink' function?

I am trying to use the 'hyperlink' function to compose URL addresses with the
'concatenate' function, but when the finished character string exceeds 255
characters in length I get an error. The problem seems to be with the
'link_location' field in the hyperlink command and not with the 'concatenate
function'.

Is there a way to increase the character limit for the 'link_location' field?
--
Brad Bettman