View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default algorithm to INVERT a multiarea selection ?

Hi KeepITcool,

Given your time zone, this must be important to you.

How's this for methodology?

Your function approach looks good.

so far so good :)

As the blind man said, stepping off the cliff!


I've been thinking of a different approach which is either very sensible or
utter lunacy.
I am loathe to say more for obvious reasons!

By the way, the Inverse function should error check that RngA <
Usedrange - Obvious, but I failed to allow for it.


---
Regards,
Norman