Union and Intersect range... but any SUBTRACT?

R

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
 
R

Ray Price

Very cool, thank you!

Any chance this will make it into Excel one day?

David McRitchie said:
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Ray Price said:
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?
Click to expand...
Click to expand...
 
Top