View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Sherry John Sherry is offline
external usenet poster
 
Posts: 4
Default Programming Excel with VBA: How to make Selection Nothing

Thanks Tom,
Range(A1").Select leaves "A1" selected.

Selection(1).Select leaves top left cell of range selected.

Tried Selection(0).Select, it leaves cell to left of top left cell of range
selected.

Am I asking too much of Excel to expect that there can be no cell selected?

Best regards

"Tom Ogilvy" wrote:

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