Hi All,
I am having two columns - First column has Link (Url) and 2nd Column has Friendly Name.Using HYPERLINK formula,
I am able to create the Hyperlink in excel but to make it dynamic, I need to use VBA Code.
Kindly let me know how I can use the HyperLink formula - "HYPERLINK(I9,H9) " in VBA Code to achieve below Output.
<tbody>
</tbody>
Please note the above table list is dynamic. Based on the filters selection, the urls and no . of urls can change.
With Regards,
Gauraw
I am having two columns - First column has Link (Url) and 2nd Column has Friendly Name.Using HYPERLINK formula,
I am able to create the Hyperlink in excel but to make it dynamic, I need to use VBA Code.
Kindly let me know how I can use the HyperLink formula - "HYPERLINK(I9,H9) " in VBA Code to achieve below Output.
Url | Name | Output |
www.google.com | ||
www.yahoo.com | Yahoo | Yahoo |
www.mrexcel.com | MrExcel | MrExcel |
<tbody>
</tbody>
Please note the above table list is dynamic. Based on the filters selection, the urls and no . of urls can change.
With Regards,
Gauraw