Invert Selection of Cells

I'm trying to highlight a bunch of cells in clusters not close together, and then invert the selection so that all cells BUT these are selected (therefore capturing all possible cells that someone could scroll to). In XL03 you could go to File > Invert Selection and it would work fine. But in XL07 which I have now, there doesn't seem to be a way to do it. Also, when using ctrl^a to highlight everything, and while still holding control in XL03 you could de-select specific cells, not so much in 07. I need to know if there's a way to do it with no macros involved. If not, I need a macro to do such a function on any given worksheet. Thanks!

I've never heard of a standard feature to invert selection in Excel 2003 or any other version. It's easy enough (but not particularly efficient) to do in VBA, given some particulars.

Invert the selection with respect to what -- all the cells on the worksheet, the used range, the bounding box of the current selection, or ...?

Here are some range set algebra functions you can play with.

Please Login or Register  to view this content.

Select some odd collection of cells, and from the VBE Immediate window, try

Please Login or Register  to view this content.

Stop back and pick up a fresh copy -- there was an error in the RangeBox function.