Thread: Undo a Union
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
okaizawa okaizawa is offline
external usenet poster
 
Posts: 129
Default Undo a Union

Hi,

how about this example (not simple at all...)

http://hp.vector.co.jp/authors/VA016...l/ununion2.txt

--
HTH,

okaizawa


Gary's Student wrote:
What is the simplest way to undo a union?

I can expand a union with:

Set rng = UNION(rng,newstuff)

I want a function like:

Set rng=DIVORCE(rng, newstuff)

That will take rng and remove the range in newstuff.

Thanks in advance