Union and Intersect range... but any SUBTRACT?

[Ray Price]

Hi all,

I see the functions to union and intersect a range, but I don't see a
function to subtract one range from another.

Does anyone know if this function exists, or if there is a VBA function out
there to do this I can paste into my application?

Thanks!

Ray

 

[David McRitchie]

Hi Ray,
Found in a search of newsgroup archives
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100
search all words: union intersect subtract

Tom Ogilvy posted a SubtractRange subroutine in a
reply 2000-08-06 that should work for you.
http://google.com/groups?threadm=#OOGqH7$$GA.293@cppssbbsa04

 

[Ray Price]

Very cool, thank you!

Any chance this will make it into Excel one day?