Irada,
See following article.. (which is part of the very long thread.)
http://www.google.com/groups?q=g:thl...r=&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 :
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