Programming Excel with VBA: How to make Selection Nothing
Still around? i don't think anyone answered your question properly.
Application.CutCopyMode = False
This will deselect the region. The advice that there is always something
selected is wrong. There is always something activated (though that chart
thing from Tushar sounds like an exception).
"John Sherry" wrote:
Hi
I'm programming Excel in VBA, after running a PasteSpecial method the pasted
region is selected, I do not want any range selected. How can I turn off the
selection?
Anyone got any ideas on how to do this neatly?
Many thanks in advance
|