kbay808
asked on
How to modify vba code to not highlight text in red when pasting?
The below code pastes text from the clipboard that is copied from IE, but it changes the font color to red. I need to modify it so that the font color is black.
Sub Paste_Journal()
On Error Resume Next
With GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
.GetFromClipboard
Range("A3").Value = .GetText
End With
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER