Ok, I have now created another variable called RowRange

RowRange = "F" & rw & ":" & "DD" & rw this evaluates to F108:DD108 which is the correct range.

I have then tried all sorts of combinations of:-

.Cells(rw, 4).Value = "=" & CountIf(RowRange > 0)
.Cells(rw, 4).Value = "=" & Evaluate(CountIf(RowRange > 0))
.Cells(rw, 4).Value = "=" & Evaluate("CountIf(RowRange > 0"))
.Cells(rw, 4).Value = "=" & Evaluate CountIf(RowRange > 0

but I am still up against a brick wall.

Could someone please advise on the correct syntax, or I am approaching this the correct way even.

TIA
Keith