Application.CutCopyMode

[Chatters]

Hopefully this will be quick one.

I look at macros and then use them to design my own code I'm looking simply at a copy and paste macro but it gives this option with = true, false. Looking online I can't see the difference between either option. Can anyone help and explain what the difference is.

Please Login or Register  to view this content.

[mrice]

It's a flag which correlates with the 'marching ants' border that surrounds a range after it has been copied. In most cases, it doesn't do any damage taking it out if a macro records it

[Chatters]

ok so does false take off the marching ants or does true do that or does it not matter.

[mrice]

False should take them off put it doesn't really matter unless you want the visual effect.

[JosephP]

using False will clear the clipboard and can help free up memory as well as preventing the appearance of messages about large amounts of data being on the clipboard

[Chatters]

brilliant thank you very much just as an extra then if i don't include it will it default to true?

[JosephP]

no. the valid values are either xlcopy or xlcut if a copy or cut operation is in progress, or false if neither has occurred or you wish to clear the operation

[Chatters]

Ok so it will not stay in the memory if I omit this part from my code completely? Thanks a lot for your help

[JosephP]

if you cut or copy in your code via the clipboard-especially if using large data-it is wise to set it to False afterwards

[Chatters]

ok thank you