Mac Forum / Applications / Excel / November 2007

In article
<46d2af77-5125-4cc3-a47d-711d66cd1500@o6g2000hsd.googlegroups.com>,

Selection is a additive process - you can add to a selection, but you
can't subtract (i.e, "deselect") from it.

This is true for all versions of both Mac and WinXL. What you're doing
when you CMD-Click is (temporarily) adding the cell you click on to the
selection. For instance, if you have A1:J10 selected, and CMD-click on
cell D5, then, in the Immediate Window of the Visual Basic Editor,
you'll get this result (when you enter the first line):

  Debug.Print Selection.Address
  $A$1:$J$10,$D$5

If you CMD-click on a new cell, that second Area ($D$5) will change to
the new cell, but $D$5 will still be within the first Area of the
Selection.

If you want to be able to "deselect", you can use a macro to do so - see
here for one by Chip Pearson:

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