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

Try this one from Tom Ogilvy:
http://www.google.com/groups?threadm...%40cppssbbsa04


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Irada Shamilova" wrote in
message ...

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


--
Irada Shamilova
------------------------------------------------------------------------
Irada Shamilova's Profile:
http://www.excelforum.com/member.php...o&userid=12286
View this thread: http://www.excelforum.com/showthread...hreadid=276533