Hi, how do I read hyperlink when cell is like this: [image] There is no url but when I hover over the text, it shows the url. How do I get the URL?

just use a foreach loop here enumerable.Range(2,11) means start at row 2 and end at row 12 [image] then in the vba call , change the parameter to this [image] also, change the macro.txt to this to handle cells with NO hyperlinks (will output “No Link” if cell has no hyperlink) Function GetURL…

Read hyperlink from Excel without URL

Help Studio

fernando_zuluaga (Fernando Zuluaga) March 16, 2022, 3:22pm 2

hi @markosc

kindly look this

best regards!

Topic		Replies	Views
In excel hyperlink function, i want to get only url Help	5	2819	January 20, 2020
Extract url from a hyperlink of excel Help	8	5721	January 20, 2020
Extract the generated URL from formula in excel Learn excel , studio , question	9	1844	May 15, 2020
Excel - Read hyperlinks embedded in an excel (without external library) Activities excel , activities , studio , question	3	625	July 9, 2023
How to read hyperlink text from excel cell Help datatable , excel	4	3878	January 20, 2020

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Read hyperlink from Excel without URL

Related Topics