getting behind the Hyperlink

D

Darin Kramer

Hi there,

In cell A1 if have "John Smith"

This is a hyperlink with the mail to function so that when you click on
cell A1 it generates an email with John Smiths Email address eg
(e-mail address removed)

Problem - I want to see (e-mail address removed) in B1 (ie splitting the hyperlink
back to its original form) What formulae can I put in B1 to see the
actual mail address in A1?

Thanks guys!!!

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***
 
G

Gary''s Student

try this small UDF:

Function hyp2(r As Range) As String
hyp2 = Split(r.Hyperlinks(1).Address, ":")(1)
End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top