help with column looping

[new2vba]

i have multiple columns with a name followed by five #'s as such:

Name
#1
#2
#3
#4
#5

i'm want to loop through each column, and when criteria are met (ex:#4>#1), copy that column to another location and sort the numbers. i have a problem thinking in vba code, and i can't figure out how to code this logic:

for each column b to e, if row 5>row2 then....

the copy and sort which follows i think i got. Any ideas?

 

[new2vba]

something changed though...it is leaving out the first number in the sort...let me see if i can figure out why

 

[new2vba]

actually, i think it was leaving out the first number in the sort already

 

[Macropheliac]

What result are you getting. It seems fine, here.

 

[new2vba]

the results im getting consistenly put name, the first number, and then numbers 2 - 5 sorted. now that i think about the numbers i gave you last night from home (made up numbers) i can see how it would be hard to tell (they were equal in many cases)

 

[Macropheliac]

The results I'm getting are correct no matter how I change the numbers. Have you changed anything or are you still using it as it is in my previous post?

 

[new2vba]

ive tried your new code, then i went back to the old code and tried that...the only thing different is the actual numbers - but it consistently puts the first number, then sorts the other four below

 

[new2vba]

i can see from the ex we both posted last night that it was working fine

 

[new2vba]

okay, got it...ive made a change, coloring the background of all the rows except the first row of numbers, this keeps it from sorting for some reason

 

[new2vba]

ive tried a few times...once i change the background color of any row...it stops sorting the 1st nnumber

 

[Macropheliac]

Nothing else has changed? So far, I haven't been able to reproduce the problem. There must be a reason. We'll find it.

Maybe, you could send me the file again. Let me know, here, if you do. I'll be more than glad to take another look.

Mac