[RESOLVED] Copy Paste Selection Change Macro Clearing Clipboard

[tome10]

I couldn't get this to work. When I put an End If at the end of the Macro, it kept saying End If without Block If. Does Then Exit Sub not require an End If? It doesn't work, the macro still runs.

if application.cutcopymode = true then exit sub

This works;

if application.cutcopymode=false then
do macro

I've thought about doing this, but sometimes the info is not the same.

Range("D10").Formula = Range("B10").Formula

The goal is to circumvent the Selection Change Macro from exiting CutCopyMode and wiping the Clipboard.
So why wouldn't this statement work?

if application.cutcopymode = true then exit sub

Can you think of any other ways?
Can put a code in the beginning that backs up the clipboard somehow? I mean you can programatically copy paste, so why does any other macro clear the Clipboard?