I can't paste hyperlinks created from a formula.

This is a little tricky since the HYPERLINK function does not actually create a hyperlink object. You will need VBA code to do this. With the code listed below placed in a general module of your workbook, select the cells containing the HYPERLINK function and run the macro CreateHyperlinkValues to convert the HYPERLINK functions to real hyperlinks.

Public Sub CreateHyperlinkValues()

   Dim Cell As Range
   Dim URL As String

   For Each Cell In Selection
      URL = GetHyperlinkURL(Cell)
      Cell.Clear
      Cell.Parent.Hyperlinks.Add Cell, URL
   Next Cell

End Sub

Public Function GetHyperlinkURL( _
      ByVal Cell As Range _
   ) As String

' Extract the hyperlink URL, if any, from the specified cell.

   Dim Value As String
   Dim Pos As Long

   ' Look for a simple hyperlink URL in the cell
   If Cell.Hyperlinks.Count = 1 Then
      GetHyperlinkURL = Cell.Hyperlinks(1).Address
   Else
      ' Look for a HYPERLINK function
      If Left(Cell.Formula, 11) = "=HYPERLINK(" Then
         Pos = InStr(Cell.Formula, ",")
         If Pos = 0 Then
            Pos = InStr(Cell.Formula, ")")
         End If
         Value = Mid(Cell.Formula, 12, Pos - 12)
         ' Using the Evaluate function resolves both a constant value ("www.site.com") and a cell reference (A1)
         GetHyperlinkURL = Application.Evaluate(Value)
      End If
   End If

End Function

Kevin

Thanks a lot!
One part missing though, d'you know how to keep the "Friendly name" in the object?

Tank you.

Wow it worked great thanks!