Good afternoon,
Is there anyway that I can use the CountIF function in a macro that
would allow me to determine the number of "No" values in a row.
This is what I have so far, but it does not work this way... any
suggestions are appreciated
Dim rng As range
dim intErrors as integer
Set Rng = ws.Range(ws.Cells(k, 6), ws.Cells(k, 255))
intErrors = CountIF(Rng, "No")
Thanks Larry
--
lbargers
------------------------------------------------------------------------
lbargers's Profile:
http://www.excelforum.com/member.php...o&userid=32798
View this thread:
http://www.excelforum.com/showthread...hreadid=545263