Loop function including If formula

[shaunharrison]

Hi Guys, I have values in column C. (All numerical) I have a formula that say if number is between 0-24 enter <25 in Column E. How do I do a loop so that it does this for all cells in column C that have data in them. This is my current formula.


Sub Using_IF()

Dim x As Integer

x = ActiveSheet.Range("C2")

If x <= 25 Then

ActiveSheet.Range("E2").Value = "<25"

ElseIf x <= 50 And x > 25 Then
ActiveSheet.Range("E2").Value = "26-50"

ElseIf x <= 99 And x > 50 Then
ActiveSheet.Range("E2").Value = "51-99"

ElseIf x <= 499 And x > 99 Then
ActiveSheet.Range("E2").Value = "100-499"

Else
ActiveSheet.Range("E2").Value = "Over 500"

End If

End Sub

[bmouse]

Something like this probably:

Please Login or Register  to view this content.

EndNumber value is 770, because I had 770 rows of numbers. Also I don't want to be picky, but this kind of thing is reffered to as a macro, not a formula if I'm not mistaken.