CutCopyMode not working

[zvit]

When I paste data into Excel cells with AHK, those cells are selected. I need to unselect them. I tried xlApp.Application.CutCopyMode := False, but it doesn't work. Any ideas?

[boiler]

Why do they need to be unselected? But if you insist, select another cell. At least one cell will always be selected.

.CutCopyMode := False doesn't uneselect cells. It takes them out of cut/copy mode, and pasted cells aren't in that state in the first place.

[zvit]

Need to unselect because when I run the script a second time with new data, I get an error because the previous cells are selected.
Yes, that's my workaround for now, to select something else. XL_Select_Range(xlApp,"A1:A1") (using Joe Glines XL.ahk)

[flyingDman]

You're not telling us how you copy and paste. Are you using:

Code: Select all

xl.range("G6:G8").copy(xl.range("M6:M8"))

or

Code: Select all

xl.range("G6:G8").copy
xl.activesheet.paste(xl.range("M6"))

or

Code: Select all

xl.range("G6:G8").copy
xl.activesheet.Range("M6").PasteSpecial(-4104)

As far as I know only the last method leaves the target range selected.
And, BTW, you do not need a "wrapper" function to select a range:

Code: Select all

xl.range("a1").select

See here https://docs.microsoft.com/en-us/office/vba/api/excel.range.select

[zvit]

I copy the Clipboard data outside Excel and paste it into my script after running code on it.
Correct about the wrapper, I guess I can use xlApp.Sheets("MAIN-WORDS").Range("A1").Select. I'm just familiar with the XL libraries.

[flyingDman]

That's the issue with these wrappers. You forget the original functionality...

[boiler]

And to me, this wrapper doesn't really simplify anything. It just seems like needing to memorize different syntax that is at least as complex as the native syntax that is being wrapped.

[zvit]

And to me, this wrapper doesn't really simplify anything. It just seems like needing to memorize different syntax that is at least as complex as the native syntax that is being wrapped.

You're probably right, but since I have the XL.ahk loaded, I just type "XL_" and I get a popup showing me all the available functions.