Alternative to using .Value

[288enzo]

I've read a few places that using .Value is frowned upon.

I'm ashamed to say that I use it frequently and would like to know what an alternative would be to something like the following.

    Range("A12").Value = "Require vILT"
    Range("A13").Value = "Require ABE"
    Range("B3").Value = "=COUNTIFS(B16:B150,""SV-TECH*"",C16:C150,""N"")+COUNTIFS(B16:B150,""SV-BDC*"",C16:C150,""N"")+COUNTIFS(B16:B150,""SV-SD*"",C16:C150,""N"")+COUNTIFS(B16:B150,""SV-SF*"",C16:C150,""N"")"
    Range("B4").Value = "=COUNTIF(E16:E150,""Enrolled"")"
    Range("B5").Value = "=COUNTIFS(E16:E150,""Complete"",C16:C150,""N"")"

Or is what I'm doing okay in the realm of Excel?

Thank you

 

[Joe4]

Where you are setting values directly equal to a hard-coded value, you do not need it, i.e.

Range("A12") = "Require vILT"

When you are trying to set a formula, you should NOT use it, but rather use .Formula (or .FormulaR1C1 if using R1C1 notation in your formula), i.e.

Range("B4").Formula = "=COUNTIF(E16:E150,""Enrolled"")"

 

[288enzo]

Where you are setting values directly equal to a hard-coded value, you do not need it, i.e.

Range("A12") = "Require vILT"

When you are trying to set a formula, you should NOT use it, but rather use .Formula (or .FormulaR1C1 if using R1C1 notation in your formula), i.e.

Range("B4").Formula = "=COUNTIF(E16:E150,""Enrolled"")"

That saves me a few key strokes, thank you.

 

[JEC]

Or

Range("A3").Value = Evaluate("countif(E16:E150,""Enrolled"")")

 

[Fluff]

@JEC that will put the values, not the formula into the cell.

 

[Joe4]

Or

Range("A3").Value = Evaluate("countif(E16:E150,""Enrolled"")")

Just to be clear, one puts the formula in the cell, the other puts the hard-coded value (the result of the calculation) in the cell.
So use whichever one serves your purpose.

 

[JEC]

Yes, was just a suggestion. Which he can use or not

 

[288enzo]

Just to be clear, one puts the formula in the cell, the other puts the hard-coded value (the result of the calculation) in the cell.
So use whichever one serves your purpose.

That makes sense, and in the long run it's the actual result that I'm really looking for to be in the cell, not the formula per say.