Skip to Content
0
Former Member
Dec 02, 2011 at 06:54 AM

BPC does not recognize Copy-paste

94 Views

Hi,

I am using the following VBA code to find if the excel is in Copy mode.

If Application.CutCopyMode = 1 Then

DO SOMETHING

End if

As long as I copy a cell and paste it outside the BPC data range, it works fine. But if the cell where I paste belongs to the data range, the CutCopyMode shows 0. Why is it not recognizing the Copy event? Also, in BPC, once we copy a region, we can use it to paste only once. Why can't we have a normal Excel function where we can paste it as many times as we want to? Is there some compatibility issue?

Thanks,

Swathi