View Single Post
  #5   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

There will always be something selected unless you protect the sheet and set
enable selection to disallow selection. You can position the cursor off
the screen

ActiveWindow.VisibleRange.Offset(200,0).Activate

perhaps.

When you complained about pastespecial residue, I didn't realize your
request was so primal.

--
Regards,
Tom Ogilvy



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