Thread: VBA code to ascertain difference between Range1 and Range2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
  
Posts: 391
Default VBA code to ascertain difference between Range1 and Range2
2003, 2007

Would like to be able to ClearContents in the cells representing the difference between Range1 and
Range2.

If possible like:
Range3 = Union(Range2 - Range1)
Range3.ClearContents

I cannot find a function to accomplish the task. What am I not considering?

TIA EagleOne
Reply With QuoteReply With Quote