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.
Or is what I'm doing okay in the realm of Excel?
Thank you
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.
VBA Code:
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