Non-contiguous cells

[Kokomojo]

I can select non-contiguous cells by holding down the Ctrl key and clicking.
What if I select a cell that I later want to DE-SELECT? Is there a way to do
this. Clicking on the cell again while the Ctrl key is depressed does not
work. Thanks.

 

[RagDyeR]

Can't be done!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

I can select non-contiguous cells by holding down the Ctrl key and clicking.
What if I select a cell that I later want to DE-SELECT? Is there a way to
do
this. Clicking on the cell again while the Ctrl key is depressed does not
work. Thanks.

 

[Gord Dibben]

Can only be done through VBA.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/unselect.htm


Gord Dibben MS Excel MVP