Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Tue Aug 10 21:43:07 CDT 2004
Hello Group
Does anyone know how I can loop across columns from column C till the last
one ? I only know how to loop though numerics
Oleg
Sub Numbers()
Dim a As Integer
Dim b As Integer
Dim c
a = 7
Do While IsEmpty(Range("A" & a)) = False
b = 0
If Range("C" & a) <> 0 Then b = b + 1
If Range("D" & a) <> 0 Then b = b + 1
If Range("E" & a) <> 0 Then b = b + 1
If Range("F" & a) <> 0 Then b = b + 1
If Range("G" & a) <> 0 Then b = b + 1
If Range("H" & a) <> 0 Then b = b + 1
If Range("I" & a) <> 0 Then b = b + 1
If Range("J" & a) <> 0 Then b = b + 1
If Range("K" & a) <> 0 Then b = b + 1
If Range("L" & a) <> 0 Then b = b + 1
If Range("M" & a) <> 0 Then b = b + 1
If Range("N" & a) <> 0 Then b = b + 1
If Range("O" & a) <> 0 Then b = b + 1
If b >= 2 Then Range("A" & a).Font.ColorIndex = 3
a = a + 1
Loop
End Sub
-----------------------------------------
Make Money and Find Love at Finally.com
http://www.finally.com/?link=webmail