Absolute value of lastRow

[snoh8r]

I have this Formula in my VBA:

 "=IF(COUNTIF(ProblemAnalysis!R2C[" & Count & "]:R[" & lastRowProb & "]C[" & Count & "],RC[" & Count & "]=0,""No"",""Yes"")"

And have set these:

    Count = (Range(rngAddress1, rngAddress50).Columns.Count - 1) * -1
    lastRowProb = Sheets("ProblemAnalysis").Range(Left(rngAddress37.Address, 2) & Rows.Count).End(xlUp).Row

I then copy the formula down to the last row. While it's holding the absolute cell value of $A$2, It's not holding the absolute value of probLastRow. Is this possible and does it really matter?

 

[Norie]

Remove the [] around lastRowProb in the formula.

 "=IF(COUNTIF(ProblemAnalysis!R2C[" & Count & "]:R" & lastRowProb & "C[" & Count & "],RC[" & Count & "]=0,""No"",""Yes"")"

 

[snoh8r]

Thank you very much. I was pulling my hair out on this one. I ran it and it worked great.