Deselect a cell in a discontiguous range
 

If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I
deselect "A5" withouth deselecting all cells and then having to then select
all cells except "A5"? (This scenario is vastly simplified).

Thanks!

Deselect a cell in a discontiguous range
 

bad luck!
workaround: http://www.cpearson.com/excel/UnSelect.aspx

-kc
*Click YES if this helps

"Excel_VBA_Newb" wrote:

If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I
deselect "A5" withouth deselecting all cells and then having to then select
all cells except "A5"? (This scenario is vastly simplified).

Thanks!

Deselect a cell in a discontiguous range
 

This is how to solve it programatically; I'm wondering if there is a
keystroke to accomplish this?

"KC" wrote:

bad luck!
workaround: http://www.cpearson.com/excel/UnSelect.aspx

-kc
*Click YES if this helps

"Excel_VBA_Newb" wrote:

If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I
deselect "A5" withouth deselecting all cells and then having to then select
all cells except "A5"? (This scenario is vastly simplified).

Thanks!

Deselect a cell in a discontiguous range
 

You assign said keystroke to the macro.

Excel_VBA_Newb wrote:

This is how to solve it programatically; I'm wondering if there is a
keystroke to accomplish this?

"KC" wrote:


bad luck!
workaround: http://www.cpearson.com/excel/UnSelect.aspx

-kc
*Click YES if this helps

"Excel_VBA_Newb" wrote:


If I select a range of discontinuous cells (I.E. A1, A3, A5, A8), how can I
deselect "A5" withouth deselecting all cells and then having to then select
all cells except "A5"? (This scenario is vastly simplified).

Thanks!