Untested:

Application.CutCopyMode = False

or

Dim oData   As New DataObject 'object to use the clipboard
oData.SetText text:=Empty 'Clear
oData.PutInClipboard 'take in the clipboard to empty it

or

Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Public Declare Function CloseClipboard Lib "user32" () As Long

Public Sub ClearClipboard()
    OpenClipboard (0&)
    EmptyClipboard
    CloseClipboard
End Sub

Source: https://stackoverflow.com/questions/32736915/how-to-clear-office-clipboard-with-vba

Thanks for your quick response, Alex. i actually did get this from stackoverflow.com, but it doesn't even remove the first item on the clipboard, let alone clear all of it. i also tried a snippet of code from Daniel Pineault witch used the 2nd answer above where he uses Set oData = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}"), but all that does is remove the first item. Any other suggestions?

VBA to clear clipboard
https://answers.microsoft.com/en-us/msoffice/forum/all/vba-to-clear-clipboard/445a196f-6feb-4336-9600-5583842e3209

Clearing the ClipBoard
https://www.devhut.net/clearing-the-clipboard/

Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "cmd.exe /c echo off | clip", 0, True