how in code do I deselect the Copied range ( Flashing dotted line)
thanks!
Printable View
how in code do I deselect the Copied range ( Flashing dotted line)
thanks!
VB Code:
Range("D20").Select Application.CutCopyMode = False
By the way, if your objective is to copy one range and paste it to another, you don't necessarily need to select any ranges:
VB Code:
Range("D6:F6").Copy Range("D8")
thanks!
(I have created an autocopy xla.. so I turn it on.. select range.. it autocopies.. then I click elsewhere and it pastes. thats when I wanted the "deselect" to happen)