Cell selection - unselect

[uberlib]

When using the control key to select several ranges of cells, is there a way
to unselect some of the cells previously selected?
Thanks

 

[Frank Kabel]

Hi
hold down the CTRL key whild de-selecting these cells

 

[uberlib]

When using the control key to select several ranges of cells, is

there a way

Hi
hold down the CTRL key whild de-selecting these cells

I must be missing something here. While holding down the CTRL key, I can
only select more cells. (excel 2000). If I hold the Shift key down in
addition to CTRL, it de-selects all the previously selected cells (when I
left click).

 

[Jim Rech]

Frank!

You're slipping! Get some sleep!<g>

--
Jim Rech
Excel MVP
| Hi
| hold down the CTRL key whild de-selecting these cells
|
| --
| Regards
| Frank Kabel
| Frankfurt, Germany
|
| | > When using the control key to select several ranges of cells, is
| there a way
| > to unselect some of the cells previously selected?
| > Thanks
| >
| >
|

 

[Frank Kabel]

Hi Jim
it's not that late. Don't know how i came to this idea. Think it was a
different program with this kind of behaviour???

 

[Gord Dibben]

uber

Not possible without some VBA coding.

See this google search thread for some code from Chip Pearson.

http://www.google.com/groups?threadm=#[email protected]

If not familiar with VBA and macros, see David MCRritchie's :getting started"
pages.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP

 

[Dave Peterson]

Windows explorer (and other "nice" programs!)

Hi Jim
it's not that late. Don't know how i came to this idea. Think it was a
different program with this kind of behaviour???

 

[Frank Kabel]

Hi Dave
no in this case it was more a custome developed ledger application for
an investment bank ))

 

[uberlib]

Thanks,
I'll save the link for when I have a little more time.