ExcelBanter - getting to the web link Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - getting to the web link Excel 2003 (https://www.excelbanter.com/excel-programming/333838-getting-web-link-excel-2003-a.html)

Neil Jarman

getting to the web link Excel 2003

Hi,

I have a document with cells which are also hyperlinks

I would like to be able to investigate the value of the link, to extract
data from it - i dont want the actual link, just part of it.

I tried 'worksheets("Sheet1").Cells(15,3).hyperlink' but this didn't work

many thanks,

NEIL

All times are GMT +1. The time now is 02:32 PM.