Trying to 1) remove the hyperlink, and 2) format paint (.PasteSpecial xlPasteFormats) a preferred non-contiguous range upon enter-click after entry of an e-mail address, that by default, jumps to Excel's normal style. Cannot get it to work. Help appreciated.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Address = "$L$48" Then
On Error Resume Next
Application.EnableEvents = False
Target.Hyperlinks.Delete
Range("L36").Copy
Target.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Application.EnableEvents = True
On Error GoTo 0
End If
End Sub
Bookmarks