Why is adding hyperlinks using VBA failing?

That's quite a complex way to approach a simple macro. You don't need to retrieve all the cell values into a Variant. You're also using the wrong dimension of the array - UBound(va, 2) will return the number of columns, not rows. How about simplifying like this:

Please Login or Register  to view this content.

WBD

Thanks, but this is giving a runtime error. See the attached file. I've run into this issue in different ways I've tried approaching it.
It won't let me add a link to shared file, nor does it let me upload a file. The dropdown for managing attachment is blank.

Appreciate it!

No attachment ...