Hello,
How do I set a range such that when the user sees the input box he can select no contiguous cells. How can these cells be united into a simple united range.
I tried this but no luck :
Your help is appreciated.
Please Login or Register to view this content.
Are the responses at
http://www.mrexcel.com/forum/excel-q...box-union.html
helping?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Cross-posted and answered at http://www.mrexcel.com/forum/excel-q...ml#post3773187
Entia non sunt multiplicanda sine necessitate
Thanks for the suggestions. My code is already written to access elements in the range (rng(i)). If I select the first 5 contiguous cells and then select another cell that is not contiguous and say rng(6) it returns a cell that I didn't even select which is the cell contiguous with the first 5 that I selected.
Please Login or Register to view this content.
Please why no answer ?
Crossposting on multiple forums usually works against you, no one wants to spend time working (for free!) on a problem you're working on other sites, too. Feels like a complete waste of time, our time that is.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Well I never knew that MrExcel and Excel forum were the same sites or interrelated. And also I posted the question first on Mr. Excel. It was the third thread that I have created and for the third time nobody answered. So I decided to post here, given that here too is a place where one is allowed to post questions. I have no idea why I don't get answers at MrExcel.com and I hope not to use their forums again. So I hope I'm understood.
While not related, a lot of the answerers visit both Mr. Excel and Excel Forum. This link explains why and how cross posting can be done to your advantage. As it is, no one thinks poorly of a (first time) cross poster. We do think that a first time cross poster is inexperienced in getting help from Excel forums, hence my link to this article
http://www.excelguru.ca/content.php?184
In general when one is working with discontinuous ranges, one has to loop through the Areas of the range.
It sounds like your issue isn't with the InputBox getting the discontinuous range, but the handling of that range once gotten from the user.
I admit, I tried to cycle through the areas of a selected range using the InputBox to test for ranges with more than one cell in the "area", if they select the contiguous cells one at a time it puts a comma between them and thus the Range definition stores them as separate areas so that didn't work.
what are you trying to do with the ranges?
it might be easier to split the selection into an array or ranges and cycle throught them.
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks