for each c

[Cascade]

I've noticed you can use the letter 'c' to refer to every single cell within a looping range:

Sub ApplyColor()
Const Limit As Integer = 25
For Each c In Range("MyRange")
If c.Value > Limit Then
c.Interior.ColorIndex = 27
End If
Next c
End Sub



so i just like to clarify what;
"For Each c" ... actually means in VBA

haven't been able to find it anywhere.

can you use the letter c for non looping procedures?
like

for each c in range("a1:a10")
c.value = 1


thanks alot
chrs.

 

[Scott Huish]

c is just a variable. It could be any valid variable name. In that example, c should be dimmed as Range. It's a For Each Loop. This is in the help file.

 

[jbeaucaire]

Don't be so literal. You can decide what your variables are going to be. I'm not a huge fan of using single-letter variables, but it does make some smart-looking code.

I also like to intentionally declare my variables at the top of my macros, indicating the variable name I want to use and what type it is.

If I have a large range of cells and want to process them one cell at a time, those are range variables.

Sub Test()
Dim cel as Range
Dim Limit as Long

Limit = Range("C2").Value

For Each cel in Range("MyRange")
    If cel.Value > Limit Then cel.Interior.ColorIndex = 27
Next cel

End Sub

I know this is just an example code, but I would be remiss if I didn't point out that you don't need VBA to color cells that pass a certain known value, you can do that directly on the worksheet in the MyRange cells using Conditional Formatting.