Forum Discussion
Solved
Why is adding hyperlinks using VBA failing?
Hello, Could you assist me in finding where the flaw is? The data is as follows: A B C D E F G to Populate Ticker Data1 Data2 Data3 Data4 URL AMD https:/...
I see two serious problems:
1) The URLs contain #. Excel cannot handle URLs that contain #.
2) The URLs are extremely long - up to 4812 characters in length. I'm not sure Excel can handle that.
If I try to convert the values in column G directly to hyperlinks, they don't work...
I'm afraid I don't have a solution for you, sorry.
HansVogelaar of course.
I see two serious problems:
1) The URLs contain #. Excel cannot handle URLs that contain #.
2) The URLs are extremely long - up to 4812 characters in length. I'm not sure Excel can handle that.
If I try to convert the values in column G directly to hyperlinks, they don't work...
I'm afraid I don't have a solution for you, sorry.
- I didn't think we'd stumble upon this. Appreciate your time and the contributions you've made to the community through the years! All the best! Dank y wel.