HYPERLINK - How to get around the 255 characters limit? _(VBA)

[ray_b]

As suggested in this thread, HYPERLINK function Issue , it looks like I would need a VBA code to get around the 255 characters limit of the HYPERLINK function.

Has anyone seen something like this before?

The function HYPERLINK always returns to #VALUE! when I try the following:

=HYPERLINK(B1&B2&B3&B4&B5,Link)

Where;

And;

Link part 1: Stockwatch
Link part 2: AAPL
Link part 3: &region=
Link part 4: U
Link part 5: &d1=20190819&d2=20191218&per=d&npdivs=20&width=830&priceheight=400&ptype=candle&indheight=100&log=F&ind1=none&ind2=none&ind3=vol&ind1p1=12&ind1p2=26&ind1p3=9&ind2p1=12&ind2p2=25&ind2p3=50&ind3p1=12&ind3p2=25&ind3p3=50&pov1=mae&pov2=mae&pov3=mas&pov1p1=50&pov1p2=&pov2p1=8&pov2p2=&pov3p1=20&pov3p2=&newsInd=T


I should get a new link every time a change occurs in cell B2 and B4.

Thanks

 

[AT BABU]

use Concatenate Formula

=CONCATENATE(B1,B2,B3,B4,B5)

 

[ray_b]

Thanks @AT BABU for your follow up!

The matter was taken care of in this thread:

HYPERLINK to display images

Hi all; I have been going through multiple examples on the web over the week trying to get this working to no avail.. Throwing in the towel and asking for some help! Here's what I am looking for: Select a stock ticker (and its region) to display a specific chart. It would look like something...

www.mrexcel.com

Thanks