LinkBack URL
About LinkBacks
What is the correct syntax if I want to replace two named ranges below to Rng and Rng2 in my code? Thanks!
Please Login or Register to view this content.
What is the correct syntax if I want to replace two named ranges below to Rng and Rng2 in my code? Thanks!
Please Login or Register to view this content.
Last edited by jman0707; 11-24-2008 at 05:24 PM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks shg! Target needs to be in there somewhere as well though. So right now if the target either intersects F17:F116 OR K17:K116, then it runs. So can I put
Or will that only run if they all 3 intersect (which can't happen)?Please Login or Register to view this content.
Hello Jman0707,
All the range arguments in the Application.Intersect function have to share at least one or more cells in common for a range to be returned that represents the cells that overlap. Since Rng1 and Rng2 are fixed, target, which can vary, will determine the result.
Sincerely,Please Login or Register to view this content.
Leith Ross
To test if Target is in Rng1 or Rng2 (or both),
Please Login or Register to view this content.
Last edited by shg; 11-24-2008 at 04:26 PM.
OK. I got it to work with the union formula. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks