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