TextToDisplay

[Gerrit.B]

I use following code in VBA to create URL.

URL = "http://wwwapps.ups.com/WebTracking/processRequest?HTMLVersion=5.0&Requester=NES&AgreeToTermsAndConditions=yes&loc=en_nl&tracknum=" & ActiveSheet.Cells(11, 1).Value

What do I need to change to show only ActiveSheet.Cells(11, 1).Value instead of the long url.

 

[Comfy]

Hyperlinks.Add Method (Excel)

Use a Hyperlink