Application Cut Copy Mode

[lts_ram]

Hi,

I am new to excel vba. I am using ms office ver.2016. I am trying to transfer a data though copying a range containing text values in one workbook to another workbook using macro. Although I could copy the contents, I am left with one problem. I am not able to disable the copy action i.e. marching ants.. after the macro ends. I am trying to use the code: Application.CutCopyMode = False, but the intellisense is not popping up the option False or True. Instead it shows xlCopy or xlCut Option. Please guide me how to figure out this problem.

I am attaching the code for finding out the technical errors in it.
With regards,
lts_ram

[leelnich]

That's normal. Just use False, and perhaps select a cell (optional).

Please Login or Register  to view this content.