Which Range is currently being Cut or Copied ?

[Jaafar Tribak]

Hi dear forum members,

I have a vba situation where I need to know the address of the range that is currently being copied (or cut) ie: when Application.CutCopyMode <> 0 .

I wonder if I am overlooking some easy solution or missing something obvious.

Regards.

 

[mikebinz]

Excellent stuff thanks Jaafar

I note that the code works in all Open Workbooks which I needed for my Project

I needed to add Application.ScreenUpdating = False to CmndBrs_OnUpdate() to stop the screen flickering when it fired in the CmndBrs_OnUpdate() Workbook