ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I change 255 character limit in 'hyperlink' function? (https://www.excelbanter.com/excel-worksheet-functions/61519-how-can-i-change-255-character-limit-hyperlink-function.html)

Brad B.

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


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com