Thread: Programming Excel with VBA: How to make Selection Nothing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Programming Excel with VBA: How to make Selection Nothing
Range("A1").Select

or

Selection(1).Select

--
Regards,
Tom Ogilvy


"John Sherry" wrote in message
...
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


Reply With QuoteReply With Quote