Reply to thread

Message: [QUOTE="Jialiang Ge [MSFT], post: 6923598"] Hello Dave, There is not a direct method to decide if a Range contains anther, but you may try to use Application.Intersect. Application.Intersect returns the intersection of two ranges. It return null if range A does not have intersection with Range B, in other words, if Range A does not contain Range B. If you have any other concern or need anything else, please feel free to let me know. Regards, Jialiang Ge (jialge@online.microsoft.com, remove 'online.') Microsoft Online Community Support ================================================== For MSDN subscribers whose posts are left unanswered, please check this document: [URL]http://blogs.msdn.com/msdnts/pages/postingAlias.aspx[/URL] Get notification to my posts through email? Please refer to [URL]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif[/URL] ications. If you are using Outlook Express/Windows Mail, please make sure you clear the check box "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at [URL]http://msdn.microsoft.com/subscriptions/support/default.aspx[/URL]. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. [/QUOTE]

Verification