[RESOLVED] Counting non-blank cells in constantly changing range

[onmywayup]

try like

NumOfWorkers = Application.CountA(Sheets("Paycard").Range("F3:K" & rw)

where rw is your row variable

Definitely appreciate the input, but that route doesn't get the job done.

.Range("F" & rw:"K" & rw) returns a compile error.

As does a whole set of combinations like:

.Range(""F" & rw: "K" & rw"")


I need to be able to change the row variable for both sides of the range.