Hello,

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

example:
Range A1:D5000 is selected.

Now i want deselect some cells.
maybe B500, C700 B700:D600 or something like that

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


wkr
Rober

--
Message posted from http://www.ExcelForum.com

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


NickHK

"Handler Robert " wrote in
message ...
Hello,

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

example:
Range A1:D5000 is selected.

Now i want deselect some cells.
maybe B500, C700 B700:D600 or something like that

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


wkr
Robert


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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

"Handler Robert " wrote in
message ...
Yes it can happen, that a range with 20.000 cells get selected.


---
Message posted from http://www.ExcelForum.com/

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

--
Regards,
Tom Ogilvy

"Handler Robert " wrote in
message ...
Yes it can happen, that a range with 20.000 cells get selected.


---
Message posted from http://www.ExcelForum.com/