I don't want to resort to SendKeys "{ESC}"
"Application. CutCopyMode" just turns off the Copy feature (when you select a range for copying and then select copy). Some range always has to be selected. So, to unselect the original range, just select another cell/range.
Use of the esc key is one of the more common & works fine here. Also, double-clicking a cell [to go into Enter/Edit mode] should clear them as well, as should just selecting a cell & typing content.
application.cutcopymode = false
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With