Hlp! Reverse select in range

[dee]

Hi,

Was wondering if there is a shortcut key or hidden toolbar button that
reverses what I have selected in a data range. For example, if I have a
range from A1:M30 and select from C10:E20 and then wish to just click a
button to deselect C10:E20 and select the other cells in the range.

 

[Bob Phillips]

No such button/function. How would it know what the other range is to select
from? You would have to code something specific, not trivial I fear.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Stefi]

http://www.asap-utilities.com/
has a feature that does the job: Select>Inverse selection

Regards,
Stefi


„dee†ezt írta:

 

[dee]

As I suspected! Thanks for your time and input.
--
Thanks!

Dee

No such button/function. How would it know what the other range is to select
from? You would have to code something specific, not trivial I fear.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[dee]

Thanks - I'll check it out.
--
Thanks!

Dee

http://www.asap-utilities.com/
has a feature that does the job: Select>Inverse selection

Regards,
Stefi


„dee†ezt írta: