Deselect of Cells

[Handler Robert]

Hello,

I'm looking for a way to deselect cells within a selection.

example:
Range A15000 is selected.

Now i want deselect some cells.
maybe B500, C700 B700600 or something like that

Is there a fast way to do this? Without looping through each cell o
the selection?


wkr
Rober

 

[Nick Cranham]

Handler Robert,
Do you really need to select 20,000 cells in the first place ?


NickHK

 

[Handler Robert]

Yes it can happen, that a range with 20.000 cells get selected

 

[Nick Cranham]

Handler Robert ,
If it's by the user, then they are not likely to be able to see what they
are doing.
If it's in code, you can just refer to the desired ranges without selecting.

Unless there's another reason.

NickHK

 

[Tom Ogilvy]

In code
The only way you can deselect is by selecting something else. So if you had

A1:B4 selected, to unselect B4 you would have to select A1:A2,B1

Range("A1:A2,B1").Select