ExcelBanter - character limit in hyperlink function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - character limit in hyperlink function (https://www.excelbanter.com/excel-worksheet-functions/61677-character-limit-hyperlink-function.html)

Brad B.

character limit in hyperlink function

I believe that I am encountering a 255 character limit for the
'link_location' value in the 'hyperlink' function. I am concatenating
several cell's data to compose an address, but run into problems when I
exceed 255 characters.

Is there a way to work around this?
--
Brad Bettman

All times are GMT +1. The time now is 01:37 PM.