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
|