I have used this so much I cannot do without it - it is a quick method to find all the ranges within a range than containing a value. The function is
This can be called with
Please Login or Register to view this content.
Then simple matter of iterating through myRange to get all the ranges with the value. Could not live without this great function. Very robust.Please Login or Register to view this content.
Last edited by smuzoen; 07-05-2012 at 08:45 PM. Reason: Amended code - correct error
Hope this helps.
Anthony
Pack my box with five dozen liquor jugs
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?
You can assign default values to the arguments in the signature:
In addition, and notwithstanding that it appears as an example in Help, this line makes no sense:Please Login or Register to view this content.
In the code here, c cannot be Nothing (that's already been tested), and if it were, c.Address would generate a runtime error.Please Login or Register to view this content.
Last edited by shg; 07-05-2012 at 11:56 AM.
Entia non sunt multiplicanda sine necessitate
I've been using a similar loop but didn't know about the UNION trick...that kicks a$$
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
@shg you are dead right - my bad - it should be
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks