Select Inverse

[Irada Shamilova]

Hi everyone,

I wonder if there is any method in VB or Excel that allows to select
inverse of selection. Those who use Photoshop whould easily understand
what I mean. It's when you make a selection then by choosing "Select
inverse" you inverse the selection to everything else outside of your
original selection. The further manipulations would then affect
everything else but your original selection.

Regards,
Irada

 

[keepITcool]

Irada,

See following article.. (which is part of the very long thread.)

http://www.google.com/groups?q=g:thl302938958d&dq=&hl=en&lr=&selm=xn0dl9
eh42caz7d00o%40msnews.microsoft.com

the conclusion.. it can be done quite easily..

provided: the multiarea doesnt get too complex
it helps: if the sheet doesnot have validation AND conditional formats
(as either of these properties are used in the routine)




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Irada Shamilova wrote :

 

[Rob van Gelder]

I've seen various attempts, some using Data Validation.

Try this one from Tom Ogilvy:
http://www.google.com/groups?threadm=#OOGqH7$$GA.293@cppssbbsa04

 

[keepITcool]

link doesnt work..

i'll try again..
http://www.google.com/[email protected]
ft.com

it incorporates Tom Ogilvy's idea (from the thread mentioned by Rob)
but if Validation is already used, it tries FormatConditions as
alternative)





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


keepITcool wrote :