I guess I was thinking about Windows Explorer where you CAN pull that off
without the assistance of a macro. I jumped up from Excel XP right up to
Excel 2007 and perhaps I was remembering incorrectly.

Thank you for the macro. I'll see how that works.

"Gord Dibben" wrote:

To the best of my knowledge you have never been able to de-select as you state
in any version of Excel and is not a "new wrinkle".

Perhaps you had a macro to de-select cells when using CTRL + click?

Chip Pearson has code to allow the de-selection of a cell or range of cells.

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


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 14:01:02 -0800, Robin R
wrote:

"You cannot cancel the selection of a cell or range of cells in a nonadjacent
selection without canceling the entire selection."

Whose brilliant idea was this? I used to be able to check sums by selecting
or deselecting cells. This new wrinkle makes life much harder. Is there a
way around it?