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
|