View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Allen_N Allen_N is offline
external usenet poster
 
Posts: 32
Default 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