Repeat code without writing same code

My guess is that you have absolutely no idea what programming is, you probably picked something up and then decide, "I'll just repeat it until I'm done"
Your code starts fine then the loop and there you absolutely lost it, sorry but that's it, straight forward.
Why don't you use the c.row instead of writing out every ror? "B4" "C4" "D8" etc. etc
Replace all the occurrences RANGE("?3") with Range("?" & c.row) you do that for all the ones with the 3 in it and remove all the other ones.

Hope this makes a little sense to you. Happy coding

Try this version of your code:

Please Login or Register  to view this content.

Minor chnage with the array

Please Login or Register  to view this content.

This will redimension the array as you go then you go an the array will be the same dimension as the data in it.

Minor change with the array

Please Login or Register  to view this content.

This will re-dimension the array as you go then you go an the array will be the same dimension as the data in it.

I don't know what you're doing but this just about the vba code

My guess is after looking at your coe, all the rows of code you repeated are identical except for the row number so my guess is this will work, the advantage... If you add more rows of data you do NOT have to modigy the VBA code.

Hope it works for you.

Noobs can become experts too, look at me LOL

Sorry, my mistake, I typed it outside Excel in an Editor

Please Login or Register  to view this content.

I forgot the .Row between the ))

Loose the last ) after Row

I'm just typing it in so no check on-the-fly from Excel's VBA

Is it possible you attach a sample file with non-sensitive data so that I can see if I can figure out what may be going wrong?
You could also step through the VBA code by opening the VBA editor, select the beginning of the macro and press F8 that way you can take it line for line

I did a search and replace and ALL where replaced with c.Row

Please Login or Register  to view this content.

This way should be

Please Login or Register  to view this content.

BTW I get all none with the data you put in your post

You don't need the Edn With becasue I removed the first With, it's unncessary:

I pasted the data for Sheet 11 and tried it, just to make it clear I edited the VBA code to make sure it checks .Value

Please Login or Register  to view this content.

And the result is none and that is true according to the conditions you have laid
The result for each row in a text file:

Please Login or Register  to view this content.

It shows each Row
The column checked and the value and the end if it's true or fale

I change column E in the last row to 118 and then I get both TRUE and the G instead of none

You mention Sheet 8 but this code you hard coded for Sheet 11.

To make it work for sheet 8 I would suggest a variable for the Worksheet and then set it to the active worksheet

If you want to play with VBA you must go into it a little more and practice by trial and error will get you very far, I started from scratch (okay somewhere around 1995) but still I started by trying and still do that to learn new techniques

This code should NOT be in a Sheet is should be in a module

Edited: uploaded.

Well, next step, nice to post an xlsx file, this is NOT the file with the macros so please, upload the file WITH the macros, that would be an xlsm file.
Read how to upload, so just create the file again make sure to save it as an macro embedded file, how hard can it be?

I'll pick-up the file and see what you mean and also see if i understand it.
I'll let you know.

Let me get to it right away.
I am suming that it's the Module5 macro sorttest your want me to look at.
Okay, first and VERY important, you do not refer to the worksheets or even test if you're in the correct worksheet.
This is a very risky situation.
Take your ClearSort maro
you just select the ranges and clearcontents, I imagine that if you're in the correct worksheet that is okay but what if you have a worksheet with data in columns a though z and then you accidentally clear the contents of columns F through H the first 500 rows, I imagine your memberslist database would be very much in trouble or another one which has been painstakingly filled.

I hope you can imagine and undestand my concern.
A macro is a stupid and dumb piece of sequential instructions that does exactly what the programmer has put into it and has no intelligence whatsoever.

Please tell me if my assumptions are correct:
ClearSort is to clear the contents of columns F-H in Sheet 8 (I would better give this sheet a descriptive name like Weight Group or whatever

sortest is the macro that checks Sheet 8's values and compares then to the table in Sheet 11 so that column F in Sheet 8 gets filled?

If this is correct then the MAcro sorttest does NOT in anyway indicate that it requires the data of Sheet 8 to x-check with sheet 11.
You just mention Sheet 11 but if somebody starts this macro directly from the macro list and has by accident Sheet 3 as active sheet, my guess you're going to loose data in column F of that sheet.

If they only use the buttons then maybe you can avoid this but the macrolist is always availabe from the menu bar

Hope my comncerns are clear to you and if I have been able to explain myself correctly

Like I said, I'll check is out and get back to you later in the morning, I've got some ore things to do right now

I had to finish it.
I did NOT check your code I corrected my code which you named TextBox4_click
I did fix the Clear button (simplified it)
I used the Sheet8 and Sheet11 names so if you change the sheet names you will have to do so in my modified code too.
Here's my file and it looks like it works, I get several G's

The strange thing is only the last rows return a group (G) with my code while the others return none, as far as comparing what your code does and mine I could not detect any differences.

If it's not problem, could you send your file as you are using it now so that I'm sure we're using the same version?

Thanks, will take a shot at it again, don't know if I'll be able to get to it tonight else tomorrow

Okay, here's the working code for TextBox4_Click

Please Login or Register  to view this content.

Your approach threw me completely off with the Select Case True
I modified all that and now it works

Re: it landed in column G not F
Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Re: if it doesn't meet the criteria I need it to say "none".
Which ones should say "None"?
I changed the values in the code to -0.1 and +0.1 to have the full numbers included.
If you say >5 than 5 itself is not included.
For example, if you want to check if it is more than 5 and less than 10, that would only be 6, 7, 8 and 9.
If you want to have 5 and 10 included, you can check for 4.9 to 10.1
That can be changed without problem but first let me know which ones should say "None". (Manually check all)

If you know you have some in there that should say "None", try this maybe.

Please Login or Register  to view this content.

I should have mentioned that this is probably more like it. No need to add or subtract the 0.1.

Please Login or Register  to view this content.

My mistake was that I forgot the Exit For if the condition was met.
The Select Case statement is really unnecessary because it is not True or False situation.
Your first check it to see if the cells is not empty, then a loop to see in which group the member fits and if found set a flag (i used x=1) and exit the loop
Upon exiting the loop check if the flag was set, if yes ten continue if not then fill in "none"

This about covers everything so if you decide to add another criteria to the chart in Sheet11 it will be taken into account without having to modify the vba code unless you move around columns

I hope this explains my approach and it was Jolivane's code that triggered the exit for which I had overlooked

@jolivanes: I stand corrected, however my first statement was meant sarcastically and the second, I went too far on that one.