Excel VBA question

don't really understand:

    Dim url As String
   
    url = Sheet1.Cells(1, 1) '' this is a hyperlink
    MsgBox url

all i get is text what do you mean by the 'link'

Ok - try this - this is with the 'Selection'.  You can also use it with the 'Worksheet'.


Dim h As Hyperlink

For Each h In Selection.Hyperlinks
    MsgBox h.Name
    MsgBox h.Address
Next


HTH,

Wileecoy.

Hearing for further details...

Any progress AAMFK?

uh i ended up saving it as a HTML and parsing--

but ill award these points thanks

wileecoy, since an accepted answer can't be reversed i'll post a seperate Q for you here

https://www.experts-exchange.com/questions/20334794/points-for-wileecoy.html

:O)Bruintje